Tags: SSRS

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,831 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 | 22,390 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 | 18,246 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 »
SCCM Configmgr SQL Report get list of machines with one Version of application and exclude other versions

Posted on March 17, 2016 by | 0 Comments | 6,187 Views
I had requirement from team to find out the clients that have one application (example Java) with one version installed and exclude clients that have multiple versions with same application installed. Lets take simple example . I have clients CLN01,CLN02,CLN03 and CLN04 and they have different versions of Java application installed on them. PC Name…
Read more »
SCCM list all default and Custom reports with created by, modified by, data source , Path

Posted on February 10, 2016 by | 0 Comments | 2,692 Views
By default,when you install Configmgr Reporting services point role,it create lot of reports with NT AUTHORITY\SYSTEM  account and this information can be seen from log called ‘srsrp.log’ on your Site system server.If you look at srsrp.log,there will be lot of information tracked along with list of reports it created ,its path (web path) etc. If…
Read more »
SCCM Configmgr SSRS Report Quick way to check if Clients are compliant or not for all the approved patches?

Posted on February 6, 2016 by | 56 Comments | 19,919 Views
Introduction: Software update compliance is a critical aspect of maintaining a secure and well-functioning IT environment. However, reporting the compliance status for a large number of clients can be time-consuming and challenging. In this blog post, we will explore an efficient method to quickly determine the compliance status of clients for specific software update groups.…
Read more »