Hello, How the colors are allocated in the SCCM Dashboard when using SQL Queries and pies, bar etc...? It seems the "red" is never going to the "Critical" or failure items...!!!! Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Here, Steve Beaumont’s thread will help you. SCCM Dashboard - How Microsoft IT uses it http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/94505f0d-71df-4683-9bf8-af51029d4c94/Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

This does not have any information about the assignment of the colors... it seems to be random... Healthy or Responding are red.... when Non-responding and Critical are blue!!!! this does not work ... as expected for us... Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

?bump?System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Here are samples of Dashboard. Maybe you can get information from them. Part 4: SQL queries for creating Configuration Manager Client Health and Problem Management Dashboard http://blogs.msdn.com/b/shitanshu/archive/2010/10/09/part-4-sql-queries-for-creating-configuration-manager-client-health-and-problem-management-dashboard.aspxPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

All these queries are in place and when all dashboards are about errors there are not many complains except the end-users using the dashboard would like to have the color defined againts the priority (they will define!!!) of the error... I could manage this... no problem. But hwne I have Responding and Not Responding on the same dashboard it would be nice to have the blue for Responding and the Red for Not Responding !!! sorry... Thanks, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager