How to create a custom SCOM dashboard to show key Management Group information

You might have noticed that the SCCM Reporting Dashboard was released.  But what most of you don’t know is that you can use the dashboard for SCOM data.  The cool thing with the SCCM dashboard is that it’s and OPEN platform.  You can feed it a SQL query and it will display a live gauge or a graph.  This can be used query data from  the SCOM Operations DB, the Data Warehouse DB or any DB you want.

image

So how do we do it?

First we need to download and install the SCCM dashboard. You can download it at http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=27fe0d80-38c6-464a-953a-1c2edcf35c2d

Install the dashboard using the guide that comes with the download.

** If you don’t have SCCM that’s ok.  The install is just asking for a database.  So just type in the name of the Operations Manager Database.  Make sure the username and password has permissions or the install will fail.

Input the information from the SharePoint installation.

clip_image004

After it’s installed your dashboard will look blank like this.  That OK it’s just because it doesn’t have any data to pull from.  So lets give it some data.

clip_image006

Go to Site Actions Edit Page

clip_image007

You should now see this configuration editor

clip_image009

Enter in a Name for the data and then enter in SQL Server and Database Name

Then input a SQL query that you want to graph.

image

Here is the query I used to return back # of Agents Responding and # of Agents not responding.

SELECT ‘Responding’ as Status,  COUNT(*) as TotalMachines FROM ManagedEntityGenericView INNER JOIN ManagedTypeView
ON ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
WHERE (ManagedEntityGenericView.IsAvailable = ‘True’) AND (ManagedTypeView.Name = ‘Microsoft.SystemCenter.Agent’)
Union
SELECT ‘NotResponding’ as Status,  COUNT(*) as TotalMachines FROM ManagedEntityGenericView INNER JOIN ManagedTypeView
ON ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
WHERE (ManagedEntityGenericView.IsAvailable = ‘false’) AND (ManagedTypeView.Name = ‘Microsoft.SystemCenter.Agent’)

Now choose the type of graph you want.  I choose PieChart

clip_image012

Give it a Title

clip_image014

Then Choose Save and Close

Now go to one of the Web Parts and Select edit Modify Shared Web Part

clip_image015

In the top corner under “Select data set configuration”,  select the data set we just created. Then click OK

clip_image016

The Agent Status should now show up in the web part.

clip_image017

Click Exit Edit Mode in the top right corner

clip_image018

Repeat the process with any other data set you want to display in a graph or gauge.

26 Responses to How to create a custom SCOM dashboard to show key Management Group information

  1. Sameer April 7, 2010 at 2:53 pm #

    This is really cool..
    But more detailed steps on the setup would be helpful..
    I tried, but didn’t work for me..:( ( I am sure its my test scom servers issue)

  2. Layne April 9, 2010 at 7:32 pm #

    This is and excellent and creative use for the dashboard. I have set this up against a test SCCM database and it works great. I am now trying to get it to work against a SCOM database. I’ve given the application pool account db_owner role to the OperationsManager database and I still can’t parse or validate the query above. Thanks!

  3. Sara April 23, 2010 at 9:42 am #

    I am trying to create a new query (for SCCM not SCOM) on the dashboard and I keep getting an error “Selected values for x and y axis should not be the same.” I understand the concept of this error but when I’m configuring the new webpart, it only asks me for the y-axis value…am I missing something?

  4. Tim April 27, 2010 at 6:59 pm #

    All the steps to get the SCCM dashboard working are in the install guide. Please refer back to that for more details.

  5. Balflidoanown April 29, 2010 at 2:54 pm #

    Hey

    Really glad to get into this forum
    It’s what I am looking for.
    Hope to know more member here.

  6. Roy July 12, 2010 at 1:50 pm #

    What was the SQL queury you used to get the percentage of Agents with a particular hotfix?

  7. Soma October 26, 2010 at 11:32 am #

    Tim,

    Nice Article about SCOM Dashboard, I am trying to install it at my place but I am running into issues. I have installed all the prerequisites still the install fails and roll backs. I am not able to install it. Can you please help me to setup the dashboard?

  8. Jessica Kelley December 23, 2010 at 7:36 pm #

    This is and excellent and creative use for the dashboard. I have set this up against a test SCCM database and it works great. I am now trying to get it to work against a SCOM database. I’ve given the application pool account db_owner role to the OperationsManager database and I still can’t parse or validate the query above. Thanks!

  9. Dominique April 12, 2011 at 4:46 pm #

    Hello,
    It is excellent. I used the query above after changing the quotes (retying them) and it works. Now I was also able to add the web part AgentStatus and it is displayed during the Modify Shared Web part but after I do Apply and/or Ok and Exit it disappears…. (:

    Thanks,
    Dom

  10. Dominique April 12, 2011 at 7:05 pm #

    After some non-intuitive actions I have a beautiful dashboard

    Thanks
    Dom

  11. Dominique April 12, 2011 at 8:12 pm #

    hello,

    All looks good after refreshes and refreshes…
    Some questions:
    – is it possible to have several color in a Bar Chart?
    – Where are the settings for the refresh time of the dashboard?

    Thanks,
    DOm

  12. dominique April 13, 2011 at 9:55 am #

    I found out the refresh time for the dashboard… still in progress for the change in the color for the graph(s)…

  13. Dominique April 13, 2011 at 5:55 pm #

    Hello,
    another question, is it possible to remove the .000 in the Gauge counter?
    Thanks,
    Dom

  14. Dominique April 13, 2011 at 6:19 pm #

    One more… 🙂
    How to remove the “Show Filter” or “Hide Filter”?
    Thanks,
    Dom

  15. dominique April 15, 2011 at 7:27 pm #

    Hello,
    Is there anyway to have site and sub site linked together in the dashboard?
    Thanks,
    Dom

  16. dominique April 24, 2011 at 5:00 pm #

    Hello,

    Remaining questions on the SCCM Dashboards?
    – How to change colors?
    – How Export/Import webparts as for now the .webpart file is inported but what about the datasets?
    – How to remove “Show Filter/Hide Filer”?

    Thanks,
    Dom

  17. Warren July 29, 2011 at 6:59 am #

    Hi,

    If I try and use this solution with Sharepoint in Domain A and SCOM in Domain B which ports would I need to open?

    Thanks!

  18. Scott December 20, 2011 at 9:04 pm #

    Great Article! Managed to grab a whole bunch of different code from around the place, but the following code above gives me an Incorrect syntax near ‘‘’. Ive cut the code in half and just tried responding’, same thing? Im not a SQL guy! 🙁 Any help would be great! The query parses just not validates?

  19. Ramesh May 10, 2013 at 2:36 am #

    Could you let me know how did you remove/hide the ‘Show Filter’ from this dashboard?

  20. Rob Ingenthron May 12, 2017 at 7:11 pm #

    SCOM is like the 1990’s version of monitoring. I would love to see dashboards that more efficiently display data and better utilize the page “real estate” to better represent a collection of related data.

Trackbacks/Pingbacks

  1. www.contoso.se » Blog Archive » The System Center Configuration Manager 2007 Dashboard with Operations Manager - March 12, 2010

    […] info about the dashboard at the System Center Team Blog. Timothy McFadden posted a good post about how to use this dashboard with Operations Manager 2007 R2. I have tried this in my sandbox […]

  2. Cameron Fuller - December 11, 2010

    Using the Service Manager 2010 Dashboard for Operations Manager…

    There have been some great articles out there on how to use ……

  3. Create Custom Dashboards « Reuben Bruce – SCOM Blog - July 11, 2011

    […] http://www.scom2k7.com/how-to-create-a-custom-scom-dashboard-to-show-key-management-group-informatio… […]

  4. Create Custom Dashboards | Reuben Bruce – SCOM Blog - July 21, 2011

    […] http://www.scom2k7.com/how-to-create-a-custom-scom-dashboard-to-show-key-management-group-informatio… […]

  5. Useful Links | Everything System Center Operations Manager by Tim McFadden - February 13, 2015

    […] http://www.scom2k7.com/how-to-create-a-custom-scom-dashboard-to-show-key-management-group-informatio… […]

  6. Using the Service Manager 2010 Dashboard for Operations Manager (#SCOM, #SCSM) | Catapult Systems - April 17, 2015

    […] Timothy McFadden: http://www.scom2k7.com/how-to-create-a-custom-scom-dashboard-to-show-key-management-group-informatio…  […]

Leave a Reply