Part 1: How Microsoft IT using Configuration Manager Dashboard?

Today Configuration Manager Dashboard was released worldwide. One of the great feature of this solution is that it is customizable and extensible dashboard solution to view key Configuration Manager Datasets within a single summarized dashboard.

Microsoft IT Configuration Manager production team has deployed this solution with custom dashboards created in production for Microsoft IT Configuration Manager hierarchy which manages ~275,000 desktops worldwide and this blogs highlights some key custom dashboard created using this solution. And if you are attending Microsoft Management Summit 2010 then you could also attend the session BE01 Configuration Manager Dashboard, Monday, April 19 3:00 PM - 4:15 PM, which has demo for how Microsoft IT using Configuration Manager Dashboard.

The Configuration Manager Dashboard provides 6 dashboard dataset as out-of-box view and provides option to add more dataset for dashboard as needed. Microsoft IT Configuration Manager production team has created following custom dataset to meet the core business users requirement for commonly asked information from Configuration Manager. Also this dashboard is first release and being updated on going basis based on the feedback and business requirements.

In next part for the series, I will be sharing the details for creating below dashboard and SQL query used for configuring below dataset.

Dashboard for Machines Counts
Overall Machines Count Machines Count By Regions Machines Count By Operating System Machines Count By Server/Workstation OS Type Machines Count By 32/64 bit OS Type Machines Count By Desktops/Notebooks Type Machines By Physical/Virtual Type
Security Dashboard for Update Compliance
Software Update Compliance by Update List/IDs
Application Deployment Team Dashboard
Success Rate of Active Software Distribution Advertisements Distribution Points with Pending Packages Count Pending Packages with DP Name and Client Counts
Configuration Manager Administrator Dashboard
Site Server Count by Role Assigned Site Server Update Compliance Last WSUS Server Sync with Windows Update Last Successful Site Server Backup Date & Time Site Servers Not Communicated in last 24 hrs. Last 24 hrs. Error/Warning Status Messages Count by Site
LCD/Plasma Screen Dashboard
Last 2 Hours MP Communication Success % Overall Last 2 Hours WSUS/SUP Scan Success % Overall Last 2 Hours MP Communication Count Per Site Last 2 Hours Software Update Scan Count Per Site
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
Client Health Problem Management Dashboard
Windows Update Scan Error for Last 7days Client Health State Error Messages for Last 7days Client Deployment Error Messages for Last 7days Client Error Status Messages for last 7 days
App-V Dashboard
App-V Client Count App-V Client Count by OS App-V Client Versions Virtual Application Name, Version and Installed Count
Asset Management Dashboard
Asset Count by Manufacturer Asset Count by Model

Please share your feedback and thoughts for this dashboard dataset or any queries for using the Configuration Manager Dashboard.

Useful Links:

• About the Configuration Manager Dashboard : https://technet.microsoft.com/en-us/library/ff369719.aspx
• Configuration Manager dashboard download location: https://go.microsoft.com/fwlink/?LinkId=187322
• Quick short “how to” videos shows how to install and configure the dashboard:
  • Installing the dashboard
  • Configuring the dashboard

Disclaimer: The information on this site is provided "AS IS" with no warranties, confers no rights, and is not supported by the authors or Microsoft Corporation. Use of included script samples are subject to the terms specified in the Terms of Use

Comments

• Anonymous
  April 26, 2010
  would like to know where is the Sql queries for these Dashboard

• Anonymous
  April 27, 2010
  you can refer my part 2 blog posting for some of the queries used above and will be posting corresponding SQL queries for all of above dashboard by this weekend.. http://blogs.msdn.com/shitanshu/archive/2010/04/11/part-2-using-configuration-manager-dashboard-for-software-update-deployment-readiness-patch-tuesday-checklist.aspx

• Anonymous
  October 10, 2010
  This looks like a really series of posts from the "Configuration Manager in Microsoft IT" folks

• Anonymous
  January 05, 2011
  Hi shitanshu ! Thanks a lot for these posts. I have just one question : can I use Sharepoint Foundation 2010 instead of WSS 3.0 SP2 ? I didn't find anything relative to this ! Thanks in advance for your answer.

• Anonymous
  March 16, 2011
  Hi Shitanshu, Thank you so much for these queries, it been very useful for me. Is it possible to get a query similar to Windows updates compliance  for third party patches liek Adobe, Firefox Thanks, Vinay

• Anonymous
  April 25, 2011
  Hello, Is it possible to have the color as we "want" not per default? I have critical issues or not responding in blue!!! I have responding or healthy as red, etc.... this does not match well the purpose... :) Thanks, Dom

• Anonymous
  March 27, 2013
  Hi Shitanshu Do we have something similar for configmgr2012? How MSIT is doing for Configgr 2012. Thanks.

• Anonymous
  July 16, 2013
  Nice article

• Anonymous
  October 12, 2013
  Hi, this site is very useful ,if you have any more information please visit www.kbreducation.com

• Anonymous
  February 05, 2014
  Hello Shitanshu, first of all congrats on just a fine article, I have used several times for SCCM 2007 and works fine ! The IT managers love these dashboards to "control" things. Because I now have clients with SCCM 2012, and the dashboards aren´t available for SCCM2012, I would like to know if anybody try to use it with SCCM2012 ? and the results/expectactions about this ? Thanks in advance.

• Anonymous
  November 02, 2015
  now have clients with SCCM 2012 and  please share the  dashboards if available for SCCM2012.