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 How to generate patch compliance report that shows all updates for specific collection ?

There are couple of posts on TechNet blog and other forums asking for ‘Is there any report that list all updates with compliance status for specific collection’ ? Read it once again ,A software update compliance report that list all updates whether Targeted, Installed, Missing for specific Collection. A collection may contain X number of…
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 SSRS Report Content Status with Compliance – Console View

This post is an extension to my previous article to view the content status for the applications,packages,driver packages,software updates,windows images using SSRS report instead of Console. Few people contacted me ,if there is way to get the status /Report of all packages on all Distribution points with its compliance % and other information what is…
SCCM 2012 SQL Query count updates from Software update groups if they are bigger than hard limit 1000 or not

In Configuration manager 2012,the update limit per update-deployment group has been increased (hard limit) to 1000 where was in Configmgr 2007,it was just 500 updates.More information about the hard limit and further questions ,worth reading the blog post by Kevin http://blogs.technet.com/b/server-cloud/archive/2012/02/20/managing-software-updates-in-configuration-manager-2012.aspx The hard limit is --the list of software updates what you see in software…