SCCM Configmgr Get the Update Compliance Status for multiple Update groups against Multiple collections using SQL query without reporting

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…
SCCM Configmgr Software update Compliance Report for multiple Software Update groups per collection

  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…
How to Query Clients collection or SSRS with Online Status in SCCM Configmgr 1602

  Microsoft has introduced new feature in System Center Configuration manager Build Version 1602  called Client Online Status .This is really cool and exciting feature which is really needed these days to know if the computer is online or offline (of course ,SCCM agent must be working and healthy which is different story). A new…
SCCM Configmgr SSRS Report Quick way to check if Clients are compliant or not for all the approved patches?

Another interesting report  on software update compliance which will really helps lot of people in their daily job . Did you ever receive requests to report compliance status(in one line report) for bunch of clients for ex: specific collection ? Management or Security guys do not really care about what software updates ,the computer is…
Configmgr SSRS SQL Query How to check Client is member of what collections and its Maintenance Window

  This is quick post on How to check Client is member of what collections and display its Maintenance window . Maintenance Window information for collections are stored in view called v_ServiceWindow .Here is the excel spreadsheet that I always make it as reference for any custom queries always help to find right view. http://eskonr.com/2013/10/download-sccm-configmgr-2012-r2-sql-views/ …
SCCM Configmgr SSRS Report Get list of missing updates for client from specific Software update group

Few months ago,I posted a blog on How to get list of missing/Required software updates for specific computer .This report basically helps to identify if the PC missing any patches to confirm the device is fully compliant or not. But this report is based on all the software updates available in the SCCM and whether…
SCCM Configmgr 2012 Updated Patch Compliance reports for software update group and collection with patch progression

  Few months ago,I blogged about  SCCM Configmgr 2012 SSRS Patch Compliance Report Per Collection Per Update Group .This report tells you ,how your specific software update group (list of patches) is performing on specific collection(list of computers). It has linked report to see what computers are non-compliant for troubleshooting with some additional client information…