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 PC from specific Software update group

Few months ago,I posted blog on How to get list of missing/Required software updates for specific computer which helps to identify if a PC is 100% complaint or not for list of available patches(metadata) from SCCM,but that report gives you overall missing patches from SCCM DB irrespective of whether they are part of any software…
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…
SCCM Configmgr 2012 Create device collection using the User Department attribute

  Recently ,I have got a request from the business unit manager on the reboot of computers due to patch management (applicable to Applications as well) .The Custom client device setting ‘ Display temporary notification to the user ' (shown below) set with 480 minutes across the enterprise workstations but specific department (ex: Engineering), not…
SCCM Configmgr 2012 Software update compliant non-compliant results for list of computers from collection for specific month

Few days ago ,I was working on request to get the software update compliance (compliant /Non-Compliant) for list of clients (Desktops or servers) from collection for specific month.I have posted lot of Configmgr 2012 SSRS reports on my blog http://eskonr.com/tag/sccm-patch-reports/about software update compliant but this is something different compared to other reports. Due to the…
SCCM  2012 Collection SSRS report with No SEP client or SEP Client is older version

Rolled out new Symantec endpoint Protection (SEP) Version to clients across all the sites. After few days ,report (All application deployment –Basic)  says ,around 100+ computers still running on old version which did not upgraded to deployed version.Out of these 100+ clients,some of them already have deployed version if I check via resource explorer (also…