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'

If you execute the report via a webpage, for instance on the reporting server, you whould get the following error:

The EXECUTE permission was denied on the object 'SearchMaintMode', database 'OperationsManagerDW', schema 'dbo'.

 

So the resolution to the problem is fairly easy, give the Datawarehouse Read Account EXECUTE permissions on the object’ SearchMaintMode’. This can be done following these steps:

1. Open Microsoft SQL Server Managemend Studio;
2. Connect to the SQL server hosting the OperationsManagerDW database;
3. Browse to DatabasesOperationsManagerDWProgrammabilityStored Procedures’;
4. Open the properties of the SP ‘dbo.SearchMaintMode’;
5. Select the page ‘Permission’ (on the left);
6. Click Search;
7. Search your DRA account (for instance SVC_SCOM_DRA);
8. Grant the permission ‘Execute’ (third row, first checkbox);
9. Okay, you’re done!

imageimage

 

Ingmar Verheij

Ingmar Verheij

At the time Ingmar wrote this article he worked for PepperByte as a Senior Consultant (up to May 2014). His work consisted of designing, migrating and troubleshooting Microsoft and Citrix infrastructures. He was working with technologies like Microsoft RDS, user environment management and (performance) monitoring. Ingmar is User Group leader of the Dutch Citrix User Group (DuCUG). RES Software named Ingmar RES Software Valued Professional in 2014.

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Tags: , , ,

Comments (1)

  • Tommy
    29 June 2016 at 13:33 |

    Hi Ingmar,

    I doubt anyone still supports this report MP, as i did not found any updates or alternatives to it for SCOM 2012, but i’m having the issue that the Maintenance Start and Maintenance End date properties are way-off; but i can’t figure out what exactly causes this.

    For example:

    Operations Manager Health Check Report – Misc – Maintenance Mode
    Down Date Time: 6/25/2016 5:30:36 AM
    Restored Date Time: 6/25/2016 6:30:55 AM

    Maintenance Mode History Report
    Maintenance Start: 6/25/2016 11:26:48 PM
    Maintenance End: 6/26/2016 12:30:07 AM

    The health check report is included in http://www.systemcentercentral.com/scom-health-check-reports-v3/ which does match the maintenance mode schedule for that particular system but the downside of this report is that you can’t report for specific servers, only for a entire group.

    Any idea how to solve or are there any alternatives?

    Thanks in advance

    Tommy

Leave a comment

*

Donate

%d bloggers like this: