Dashboard showing the health of SCOM distributed applications

This dashboard that I created for one of my company’s customers shows the real-time health of the distributed applications that we created in SCOM.

This dashboard includes links to the Service Map and the Heat Map for each of the technologies displayed. These maps are stored and updated on the company’s SharePoint portal.

When the user clicks on the DA’s name “Exchange 2010” etc the SCOM web console is launched displaying the distributed application.

The dashboard refreshes every 60 seconds or when there is a significant change in the health of the different distributed applications.

The dashboard is created using SSRS 2012 with a SQL query that gets the health state from the SCOM Operations database. Please pm me if you want more details including the actual .RDL and/or the SQL query.

Advertisements

4 thoughts on “Dashboard showing the health of SCOM distributed applications

  1. Hie,
    I’m really interested by getting your SQL script. I’m currently working with Report Builder. i’m looking for getting the state of distributed application thanks to an sql query, then make a dashboard with the states forthe last 8 hours.
    It would be very hepful to get your script and your help 🙂

    Thank you

    • Hi,

      Below is the query that I’m using
      select * from
      (
      SELECT row_number() over (order by basemanagedentity.displayname) as rownumber,
      max(state.healthstate) as ID, basemanagedentity.displayname,
      ‘http://<put your web console server name in here>/MonitoringView/default.aspx?DisplayMode=Pivot&ViewType=DiagramView&PmoID=’ + convert(varchar(38), basemanagedentity.basemanagedentityid) as URL
      FROM State with (nolock) INNER JOIN
      BaseManagedEntity with (nolock) ON State.BaseManagedEntityId = BaseManagedEntity.BaseManagedEntityId inner join monitor with (nolock) on state.monitorid=monitor.monitorid
      where (BaseManagedEntity.FullName like ‘Service_%’ and basemanagedentity.displayname like ‘%Put your distributed apps names as wildcard, if you follow a naming standard%
      and BaseManagedEntity.Name is NULL and monitor.monitorname=’System.Health.EntityState’)
      group by basemanagedentity.displayname, basemanagedentity.basemanagedentityid
      ) t
      where t.rownumber between 1 and 6

      This query will show you 6 distributed applications healthstatus and name, change the “1 and 6” on the last line of the above query to a larger number to get more information. I’m running the above queries in different datasets with SSRS tables for each data set, this allows me to setup a report with different “columns”. The second data set will have “between 7 and 12” , the third data set will have “between 13 and 20” and so.

      Hope you come right, let me know if you need more information and help

  2. Very nice and creative way of displaying the dashboard via SSRS. I am currently working on building several Distributed Apps for a customer and I would like to try out your RDL and Query to see how it visualizes and performs. Can you please provide them?

    Thank you.

    • Hi Tim,

      Below is the query for the health of the DAs
      Select max(state.healthstate) as ID, basemanagedentity.displayname
      FROM State with (nolock) INNER JOIN
      BaseManagedEntity with (nolock) ON State.BaseManagedEntityId = BaseManagedEntity.BaseManagedEntityId inner join monitor with (nolock) on state.monitorid=monitor.monitorid
      where (BaseManagedEntity.FullName like ‘Service_%’ and BaseManagedEntity.Name is NULL and monitor.monitorname=’System.Health.EntityState’)
      group by basemanagedentity.displayname, basemanagedentity.basemanagedentityid

      This query will give you the healthstate (1,2,3) and the name of each Distributed Application in your SCOM environment.
      You can then put this into a report and use it as a dashboard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s