Hi All, Microsoft started a really good blog post here: http://blogs.msdn.com/b/shitanshu/archive/2010/04/08/part-1-how-microsoft-it-using-configuration-manager-dashboard.aspx on "How Microsoft IT using Configuration Manager Dashboard?" They followed up with some of the SQL queries they used: http://blogs.msdn.com/b/shitanshu/archive/2010/05/02/part-3-sql-queries-used-for-creating-custom-configuration-manager-dashboard-in-microsoft-it.aspx but have yet to release what would have been the "killer" queries in my view, the Client Health ones. So.... what I'm asking is does anyone in the community, or anyone from Microsoft (hint hint Wally) have any queries that could help with the following? Configuration Manager Client Health Dashboard Client % with Hardware Inventory in last 3 days. Client % with Software Inventory in last 3days. Client Count for WSUS Scan, Heartbeat and MP Communication in last 24 hrs. % of Inactive Client Count % of Obsolete Client Count Unapproved Client Count by Site I've started writing some myself, but I'm not the best at SQL and I always hate re-inventing the wheel! Thanks in Advance, SBhttp://www.microsoft.com/technet/security/Bulletin/MS08-067.mspx If you don't ever patch anything, for god sake make sure this patch is on.......

Thanks for changing the thread from a question to a discussion Zhang, I suppose I should have done that originally ;) Anyone got any queries they feel like sharing? I've put mine to one side as the Service Manager Authoring Tool went RC today and I've been waiting to play with it! Cheers, SBhttp://www.microsoft.com/technet/security/Bulletin/MS08-067.mspx If you don't ever patch anything, for god sake make sure this patch is on.......

Hello, The Dasdboard is great, the queries fantastics... what about the colors to be assigned as needed and not per default... critical is blue !!! not responding is blue...!!! Respondi ng or healthy are red !!! it seems reverse way as expected... is it possible to get the colors assigned manually or available for change? Thansk, DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

No need for posting the same question twice, Felyjos: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/842e5ac8-ca54-49ec-996f-9787700c854e/#5e71f1c8-2451-462a-ab51-1f72ee5241a1Torsten Meringer | http://www.mssccmfaq.de