Tag: Reporting

Installing & Configuring SCOM 2016 Reporting Feature

Some prerequisites and things to know… In my environment I am using SCOM 2016 (Technical Preview 5 (TP5)) and SQL 2014 SP1 running on Windows Server 2012 R2. On this local server (I am installing this on my SCOM SQL server) I have already deployed a default (not named) SQL instance, with Reporting Services (SSRS) installed (and already configured). If you run into issues here, please let me know.

On your local server, ensure your SQL service account and SQL SSRS account have local administrative rights on the server. Launch the SCOM 2016 installer and run as the SCOM SDK (Data Access) account.

So let’s begin:

2

3

4

5678

Let this run for a few minutes, grab a coffee, get some fresh air, etc. 🙂

9

Yay, no errors!

You should now have the Reporting function within you SCOM 2016 console. Happy (SCOM) reporting!

 

Maintenance Mode History with SQL

Unfortunately SCOM 2012R2 does not have a native report and/or view that allows you quickly view the maintenance history on a specific server or servers. This handy SQL query I have used many times over to get the history of a given server or servers to find out when the machine entered MM (Maintenance Mode). Using the query below, run against the OperationsManager (or Data Warehouse) DB, and specify the server(s) you are interested with the date range:

---
USE OperationsManagerDW
SELECT ManagedEntity.DisplayName, MaintenanceModeHistory.*
FROM ManagedEntity WITH (NOLOCK)
INNER JOIN
MaintenanceMode ON ManagedEntity.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId
INNER JOIN
MaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId = MaintenanceModeHistory.MaintenanceModeRowId

WHERE DisplayName Like 'server%.domain.net' AND ScheduledEndDateTime BETWEEN 'fromDateRange' AND 'toDateRange'