Tuesday, July 5, 2011

SCOM Dashboards - Conclusion and References

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
SCOM Dashboards - Part 7 - The SCOM Distributed Application Health State Tab
SCOM Dashboards - Part 8 - Adding the SLD Tab to the SCOM Dashboard

I hope that if you are reading this post that it means you have taken the time to review the other posts in this series and have found the information in them useful. Although I haven't come across this solution on the web previously that offers a central tabbed dashboard that includes a SCOM Admin dashboard, a SCOM Distributed Application Health State dashboard and the SCOM Service Level Dashboard, it doesn't mean that I came up with the ideas for each component all by myself.

Below are some links to the other SCOM community member blog posts that made this particular series possible and I would like to thank them for their hard work and time put in to their posts as without them I wouldn't have been able to come up with this solution.

Kevin Holman (Credit for a huge amount of SQL queries and the best resource on the web for them)

Cameron Fuller (Credit for SCSM dashboard customization)

Tim McFadden (Credit for SCCM dashboard customization)

Steve Beaumont (Credit for Distributed Application Health State Dashboard)

Anders Bengtsson (Credit for additional dashboard customization)

Finally, the purpose of this blog series is to highlight the use of dashboard solutions for SCOM that are FREE and that haven't been blogged about much in the past. I have decided to omit the dashboard integration that can be used with Visio 2010 and Sharepoint 2010 as this has been blogged about all over the web and I didn't want to go over old ground again.

I have also omitted the excellent Savision LiveMaps dashboard solution as it is not free - contrary to what a lot of people think, Savision allow the use of 5 maps for free for 12 months, then you need to purchase a licence for them. If you do have the budget to spend and are looking for an extra dimension in SCOM dashboards, then Savision LiveMaps is the only way to go.

For more information on the Visio 2010, Sharepoint 2010 and Savision LiveMaps solutions, see the excellent blog series by SCOM MVP Marnix Wolf from the link below:

Marnix Wolf

That brings this series to an end, thanks for reading and hopefully you have found the information helpful.


  1. This was awesome. This is just what we were looking for. Couple questions. I would like to have a monitor for my dash board that shows any server with under 15% of disk free left and one to show % of uptime for our servers. I have looked everyone and so far nothing comes close.

  2. Hi there,

    Thanks for the great comments about my posts!

    Would you believe that the type of dashboard you are looking for although a simple and totally understandable one to have is something of an enigma to create within a dashboard.

    I had searched everywhere for an SQL query that would satisfy a similar request I had a year or so ago and eventually found one that just about did the job.

    I'll create a new blog post about this over the coming days as I think it warrants a bit of a deeper explanation than what I can give in a single comment here.

    Keep watching the blog for the new post!


  3. You did an amazing job! Thank you for this post!

    1. No problem Jesse - thanks for the great comment!!
      Glad these posts have been of help to you!


  4. very, very nice

    from germany


  5. Thanks very much for this tutorial. Very clear and useful.


  6. Thanx for this! One thing I can nog find the DA state query on Steve Beaumont's blog. Do you still have it?


    1. Hi Chris,

      The link to Steve's DA query is here:



  7. This is one of the most finest articles I have ever seen....thank you so much