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

 

image

Security Dashboard for Update Compliance

  • Software Update Compliance by Update List/IDs

image

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

image

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

image

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

image

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

image

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

image

App-V Dashboard

  • App-V Client Count

  • App-V Client Count by OS

  • App-V Client Versions

  • Virtual Application Name, Version and Installed Count

image

Asset Management Dashboard

  • Asset Count by Manufacturer

  • Asset Count by Model

image

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

Useful Links:

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.