Category: Patch Reports

Software Update Compliance report for CMG connected devices

Posted on August 10, 2020 by | 0 Comments | 3,335 Views
With COVID-19 around the globe, the organizations who are using Configuration Manager have shown much interest in Cloud Management Gateway. Cloud Management Gateway helps you to manage the clients on the internet. For more information on how to setup CMG, please refer https://docs.microsoft.com/en-us/mem/configmgr/core/clients/manage/cmg/setup-cloud-management-gateway A customer who recently deployed Cloud management gateway, wanted to monitor the…
Read more »
What is new in Configuration Manager 2002 reporting

Posted on May 6, 2020 by | 0 Comments | 1,338 Views
Microsoft has released Microsoft Endpoint Manager Configuration Manager build 2002 (MEMCM) via the opt-in method (fast-ring) which will is now available for you to install and also baseline version however the baseline media is not yet available for the download. The baseline version will be released when the build is made available to the console via slow-ring. If you want…
Read more »
SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

Posted on July 18, 2017 by | 6 Comments | 5,311 Views
Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the…
Read more »
SCCM Configmgr SQL query to find Top X missing updates for specific collection for specific update group

Posted on August 22, 2016 by | 12 Comments | 11,235 Views
Since few days ,I am working on a customized Software update compliance dashboard report with some Pie charts for management to see how the patch compliance progress for each Business Unit (I say business unit means for each country). Management are interested to see the overall patch compliance summary for each country (focused on servers…
Read more »
SCCM Configmgr Get the Update Compliance Status for multiple Update groups against Multiple collections using SQL query without reporting

Posted on July 8, 2016 by | 12 Comments | 21,535 Views
Recently ,we had an issue with SCCM Configmgr Reporting services role (Remote SQL sitting on VM was crashed ,blog post coming soon ) and we were unable to generate reports mainly for the Software update compliance status that happens every month. This post is about ,how to check the software update compliance status for the…
Read more »
SCCM Configmgr Software update Compliance Report for multiple Software Update groups per collection

Posted on May 28, 2016 by | 43 Comments | 17,780 Views
  Long ago ,did blog post on How to get software update compliance for specific update group per collection with drill down report to list the Required/missing ,unknown clients with some additional information like recent hardware inventory, last update scan results ,OS etc . This report will only work for single software update group per…
Read more »