Tuesday, July 5, 2011

SCOM Dashboards - Part 7 - The SCOM Distributed Application Health State Tab

Before reading this post, please ensure you have reviewed my previous posts on SCOM Dashboarding from the links below:

SCOM Dashboards - The Intro
SCOM Dashboards - Part 1 - Installing WSS 3.0
SCOM Dashboards - Part 2 - Installing the Dashboard Solution Accelerator
SCOM Dashboards - Part 3 - Customizing the Dashboard Banner and Logo
SCOM Dashboards - Part 4 - Customizing the Dashboard Tabs
SCOM Dashboards - Part 5 - Installing the Service Level Dashboard (SLD 2.0)
SCOM Dashboards - Part 6 - Adding SQL Queries to the Dashboards

Next we are going to modify the 'SCOM Distributed Applications Health State' tab and provide a live view of the health state of all your DA's through the dashboard

Click on the 'Edit page' link as below to continue


Now we are going to remove all of the existing SCSM web parts simply by clicking on the 'X' beside each one until we get a screen that looks like this


Configure your Dataset exactly as shown below otherwise the DA health states and colours will be incorrect (the SQL query will be specific to your own site in relation to the DA names however and you can get the SQL query I used from Steve Beaumont's blog credited here)


The Score Card label and value information below is VERY IMPORTANT and needs to be exact!


Next up is to add a new web part to the horizontal bottom section of the screen as shown


Select the 'Microsoft Dashboard Viewer' option


Now from this newly created web part, click on the 'Edit' button, and then select 'Modify Shared Web Part' from the list


From the menu on the right hand side of the screen, select the 'DAHealthState' dataset that was configured earlier, and then click 'OK' to close the window

You should now have a tab that looks something like this



The penultimate Part 8 post of this SCOM Dashboard blog series will demonstrate how to create a new tab alongside your SCOM Dashboard and SCOM Distributed Application Health State Dashboard tabs that includes the Service Level Dashboard 2.0.

10 comments:

  1. Sorry about this again, SQL seems to be my MASSIVE Weakpoint. You reference Steves Site with the SQL Code for the DA Applications. Ive hunted all over and cannot find this? (3rd screenshot) IS IT ME?!?!?!? :)

    ReplyDelete
  2. Hi Scott,

    Not a problem at all - it took me a while to get my SQL Kung Fu in order so I know how it feels!!

    See the URL below for Steve's excellent post on the DA Health State Dashboard.

    http://systemscentre.blogspot.com/2011/05/scom-distributed-app-health-dashboard.html

    Come back to me if you need any more help!

    Kevin.

    ReplyDelete
  3. Also Scott,just to add to my above comment, I had an issue intially when using the code from Steve's post and had to make a small change to it. Read my own comments at the end of Steve's post and you should see where i've come back with the query that worked for my installs.

    Hope this helps!!

    Kevin

    ReplyDelete
  4. Hi Kevin

    Great article, really useful - thanks!

    Is there any way that we can customise the Distributed Application Health State look? We want to put it onto a big screen but the default Display Name and HealthState font / dot are too small.

    Would be great to be able to customise it so that you get a big square/rectangle/circle etc with the application name inside it and said shape then changes colour depending on the state of the application

    Is this possible?

    ReplyDelete
    Replies
    1. Hi there,

      There's no quick and easy way to customise the look of the DA Health State dashboard from my post above because it isn't actually an official SCOM solution. It uses the Scorecard view from the Service Manager Dashboard Solution Accelerator and we're restricted to using the view above (as basic as it is i'm afraid!).

      The good news however is that you can create some excellent dashboards using the Visio 2010 and SharePoint integration functionality for SCOM and this is my preferred way of customizing SCOM 2007 dashboards.

      Check out this link for more info:

      http://technet.microsoft.com/en-us/library/ee342533.aspx

      Kevin.

      Delete
  5. Is there anyway we can do this stuff in SCOM 2012 .. We see the SLA dashboards are now part of the Native SCOM console.

    ReplyDelete
    Replies
    1. Hi Vivak,

      I've deployed these solutions for customers who are using SCOM 2012 and they work pretty well however, I'm finding that due to the significant improvement in dashboarding inside SCOM 2012, most customers don't really use this solution any more.

      Kevin.

      Delete
  6. Hello,

    I am getting multiple HeathState's from each DisplayName query.

    BaseManagedEntity.DisplayName = 'Sharepoint Server Search'
    returns:
    SharePoint Server Search HealthState 0
    SharePoint Server Search HealthState 1
    SharePoint Server Search HealthState 2

    And in the scorecard it shows up as green



    ReplyDelete
  7. Hello,

    I am getting multiple HeathState's from each DisplayName query.

    BaseManagedEntity.DisplayName = 'Sharepoint Server Search'
    returns:
    SharePoint Server Search HealthState 0
    SharePoint Server Search HealthState 1
    SharePoint Server Search HealthState 2

    And in the scorecard it shows up as green

    ReplyDelete
    Replies
    1. Hi there,

      You will need to modify the SQL script and specify individually the name of each of your actual Distributed Applications. I've seen this behaviour on a couple of customer sites in the past.

      Kevin.

      Delete