Custom Operations Manager Reports

Based off of a recognized demand, I developed a management pack that provides three key reports for Operators and Administrators to leverage.  These reports were based off of queries developed by Kevin Holman and Jonathan Almquist and tuned to support these reports.  The three reports that I have included in this MP are:

  1. Maintenance Mode - Agent-Managed Systems in Maintenance:  This report will show the agent-managed systems that are currently in maintenance in the management group.
  2. Maintenance Mode - History of Maintenance for Agent-Managed Systems:  This report will show the history of Maintenance Mode activities in the management group for agent-managed systems. and rollup total duration for those systems based on the date/time parameters the report will query within.  This report is based off of an example report that was demontrated by us at MMS back in 2009.  I used this as a foundation for learning to develop custom reports using Report Builder.
  3. Management Group Health Report - This hygiene report evaluates key performance metrics that help identify management packs that require additional tuning (discovery, monitors, and performance/alert rules) to ensure optimal health and performance of the management group.  Sure you get this information today by a couple of built-in reports (I don't have access to OM now to reference those specific reports, so please bear with me), but you need to select the specific management packs and other relevant parameters.  Here we have a single report to run to summarize that information as a starting point, and you can use the other built-in reports to further evaluate and determine if additional tuning efforts are required.

No manual steps are required once you import this MP.  The reports are running against the Data Warehouse database, so you don't need to create a custom data source.

Comments (13)

  1. Can you put up a couple screenshots of the reports?

  2. I should have pointed out a while ago that I developed and tested these reports against SQL 2008 and 2008 R2, not SQL 2005.  I'll go back and modify the report schema to support SQL 2005 and test before publishing a new version.

  3. You beat me to it.  I was going to post something similar very soon.  Maybe I still will 🙂

  4. M.Mathew says:

    Upgrading DWH to SQL 2008R2 sems to have fixed the issue for me.Great Reports..Thx

  5. Aengus Moran says:

    Very useful … thanks!

  6. Lars Jørgensen says:

    Sounds great. I was going to try it out in our lab but get an error on import "This assembly is not fully signed. Cannot verify the Strong Name ".



  7. Ramesh says:

    Imported this MP, but only the directory 'Operations Manager Health Reports' is shown in the 'Reporting' node and not the actual reports. Any pointers?

  8. Ramesh – depending on the amount of activity in your MG, it takes a few minutes for the reports to get uploaded to the SQL server hosting SQL Reporting Services after you import the MP.  

  9. Ramesh says:

    Matt – I waited for long time. In fact in the reporting page, it shows that there are no items in that folder. Its been two days now. I verified in the Authoring Console that these reports are visible (set to TRUE)

    SQL Server Reporting Services

    Home >

    OperationsManager.Health.Reports Home | My Subscriptions | Help

    There are no items in OperationsManager.Health.Reports. Click Help for more information about this page.

  10. M.Mathew says:

    Matt, Am also noticing the same issue with the Reports.

  11. Ramesh and M.Mathew – can you check the Operations Manager event log on your RMS and look for error level events from the source Health Service Modules?  E-mail me directly at when you find the related event so I can review it.

    I have imported this MP in four different environments during and after testing and have not exprienced this behavior.  


  12. Ramesh says:

    yes Matt – I do see the following events ever since I imported your MP, but this refers to ‘OperationsManager.Health.MaintenanceModeHistory.Report’ which I imported and removed it earlier!

    "Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried.

    Exception ‘DeploymentException’: Failed to deploy reports for management pack with version dependent id ‘ddfa4b38-227d-71d0-48b4-a9545b8dc044’. Failed to deploy report ‘OperationsManager.Health.MaintenanceModeHistory.Report’. The report definition is not
    valid.  Details: The report definition has an invalid target namespace ‘…/reportdefinition& which cannot be upgraded.
    —> The report definition is not valid.  Details: The report definition has an invalid target namespace ‘…/reportdefinition&
    which cannot be upgraded.

    One or more workflows were affected by this.  

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Report

    Instance ID: {4AD4CCD5-57C7-6DF6-89CF-BCB0D8D642BF}

  13. Dean says:

    Has anyone figured out why these reports dont deploy in some environments?  I too am getting the failed to deploy errors and not seeing anything in the folder.  Is this an issue where SQL 2005 is still in use?

Skip to main content