Category: SSRS Reports

SCCM list all default and Custom reports with created by, modified by, data source , Path

Posted on February 10, 2016 by | 0 Comments | 2,681 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,904 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 »
Configmgr SSRS SQL Query How to check Client is member of what collections and its Maintenance Window

Posted on February 5, 2016 by | 4 Comments | 860 Views
  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/ …
Read more »
SCCM Configmgr How to generate patch compliance report that shows all updates for specific collection ?

Posted on February 4, 2016 by | 24 Comments | 42,150 Views
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…
Read more »
Download SCCM Configmgr V1511 SQL Views documentation

Posted on December 19, 2015 by | 0 Comments | 819 Views
  After the release of Configmgr V1511,really busy setting up the new lab,upgrading the stuff from Configmgr 2012 R2 SP1 to SCCM Configmgr V1511 (In Place) and doing things with it. This post is about,what are the SQL views in SCCM Configmgr V1511 that helps you to write custom SSRS /SQL queries. As you know,there…
Read more »
SCCM Configmgr 2012 Updated Patch Compliance reports for software update group and collection with patch progression

Posted on December 16, 2015 by | 40 Comments | 12,100 Views
  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…
Read more »
SCCM Configmgr 2012 SSRS Report Content Status with Compliance – Console View

Posted on November 23, 2015 by | 2 Comments | 1,482 Views
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…
Read more »
SCCM 2012 SQL Query count updates from Software update groups if they are bigger than hard limit 1000 or not

Posted on November 17, 2015 by | 0 Comments | 2,742 Views
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…
Read more »