System Center 2012 – Operations Manager Daily Report Management Pack


Attached to this blog is an example Management Pack based on my "How to create daily reports with System Center Operations Manager 2012 and PowerShell" series, this shows another way to consume data from Operations Manager and display it in a meaningful way to reduce overheads required for daily health review. This blog will be the first of many Manageability Guys - Operations Manager reports, please let me know any suggestions or improvements to this report or any future report ideas.

The report in this blog has been created using SQL Server Data Tools for Visual Studio 2012 and System Center 2012 Visual Studio Authoring Extensions  http://www.microsoft.com/en-us/download/confirmation.aspx?id=30169

In this Management Pack it draws information from the OperationsManager and OperationsManagerDW databases, as such it requires that the data reader account be given granted select permission to the Operations Manager database. Permissions can be changed via SQL Server Management Studio and right clicking on the Operations Manager database then selecting Permissions, see the below screenshot for an example of how the change should look.

When running the report it uses dynamic data sources so you will be prompted for the details below:

See the screenshot below to see what the report looks like when run:

 

 

TheManageabilityGuys.zip

Comments (12)

  1. Hi Nachi, I will take a look perhaps my date format was incorrect for other time zones

  2. Can you please clarify under which sections you see the incorrect time, I can re-write if needed.

  3. Anonymous says:

    Hello Richard….

    Sorry this might come out as a dummy question… Please how do i use this management pack?

  4. This is an unsealed MP, install in your test system as you would normal Management Packs. In order to run the report access through the Manageability Guys section in reporting through the console

  5. Hi Scott, thanks for the great feedback. Please can you run the below against the Operations Manager DB. Interested to know the result that you receive.

    Select DISTINCT UPPER (b.DisplayName) AS ‘Display Name’, AvailabilityLastModified AS ‘Availability Last Modified’,
    CASE when healthstate = ‘0’ THEN ‘UnMonitored’
    when healthstate = ‘1’ THEN ‘Healthy’
    when healthstate = ‘2’ THEN ‘Warning’
    when healthstate = ‘3’ THEN ‘Critical’ END AS ‘Health State’

    FROM ManagedEntityAvailabilityView mea

    inner join BaseManagedEntity b on mea.BaseManagedEntityId = b.BaseManagedEntityId
    inner join StateView sv on sv.BaseManagedEntityId = mea.BaseManagedEntityId

    where mea.BaseManagedEntityId IN (
    Select DISTINCT TopLevelHostEntityId
    FROM ManagedEntityAvailabilityView mea
    inner join BaseManagedEntity b on mea.BaseManagedEntityId = b.BaseManagedEntityId
    inner join StateView sv on sv.BaseManagedEntityId = mea.BaseManagedEntityId
    inner join ManagedTypeView mtv on mtv.Id = b.BaseManagedTypeId
    where mea.BaseManagedEntityId IN (SELECT BaseManagedEntityId from MT_Microsoft$SystemCenter$ManagementServer))
    and MonitorName =’System.Health.EntityState’

  6. Had some reports people couldn't download the attachment, I have just replaced.

  7. Jas Tatla says:

    Hi Richard – I have noticed an issue with the agent patch level section on the report. it displays a number of agents but does not display the patch level

  8. Hi Jas sorry for the late reply, that should mean that the agent doesn't have a patch applied. I would suggest running the following SQL query against the Operations Manager database, this will determine which agents are returning this result.

    select DisplayName , patchlist AS 'Patch_Level' from dbo.MTV_HealthService

    Order by Patch_Level

    Let me know how you get on and thanks for the feedback

  9. Nachi says:

    Hi Richard, I am part of Canada and I too imported this MP and works Great. But I noticed there is mismatch in the time that shows in the report. I can see 5hours difference. The Management Server Availability Health status shows 5PM instead 12PM. Can
    you please advise?

  10. ScottL says:

    Richard, What format should the OM DB SQL Instance connection string be? Right now, I have tried representing it a number of different ways for my clustered instance and always get an rsErrorOpeningCOnnection error. I have been trying the format virtualinstancename/OpsMgr,12345

  11. ScottL says:

    Ignore my previous comment. I just got it working properly. BTW…love the report

  12. ScottL says:

    I am seeing an interesting issue where a few of my management servers are in a warning state in the report, but are healthy in the console. Any guess as to what might be causing this discrepancy? Did I mention that I love the report? I even cut a version
    down just to show maintenance mode and grey agents for a wider distribution of engineers.

Skip to main content