Posts Tagged ‘Query failed for data set ‘OperationsManagerDW’’

Maintenance mode report in SCOM (fixed)

Written by Ingmar Verheij on May 18th, 2011. Posted in Operations Manager

Object, like computers, in System Center Operations Manager (SCOM) can be placed in a maintenance mode. While the object is in maintenance mode no alerts will be generated, as expected.

I wanted to see which objects have been placed in maintenance mode, unfortunately there is no default report supplied by Microsoft.

Fortunately Alain Côte wrote a report, along with a stored procedure, which enables me the insights requested. The management pack, containing the report and stored procedure, can be downloaded here: Maintenance Mode History Report Management Pack

There is one instruction missing in the documentation, additional permissions are required to run the stored procedure required by the report. Without the permissions the following error is displayed:

Query execution failed for data set 'OperationsManagerDW'