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 you want to find the rdl files for these reports(only for default ) ,browse <Configmgr Installation Drive>:\SMS_SRSRP\Reports . Some of the reports resides in these respective category folders ,they do not have proper naming for ex: I look at category ‘Software_Updates_-_A_Compliance’,reports are named with ‘report290,report291’…
Author: Eswar Koneti
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. By leveraging custom reports in System Center Configuration Manager (SCCM), we can provide a concise summary of the targeted, missing, and required patches for each client, ultimately indicating whether they are compliant or non-compliant in a single line. The Need for Efficient Compliance Reporting: When…
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/ You can use the below SQL Query to run it from SQL management studio or use it in SSRS Reports. Change the PC name in marked in bold letters. select fcm.CollectionId, coll.Name [Collection Name],s.Name [MW Name],s.Description,s.StartTime,s.Duration from dbo.v_R_System sys join dbo.v_FullCollectionMembership FCM on sys.ResourceID =…
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 clients and each client may produce Y Number of patches for sure from your Configmgr environment with compliance status . So when you generate report with this requirement,you know how many rows do you get ? X (number of clients)* Y (number of patches). Assume…
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 they are part of any software update group or not. Since the report is pulling the data from all the updates in SCCM, there is huge demand from my blog readers to help getting similar report but limit the report to specific software update group.…
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 are lot many changes/updates in newly released Configmgr V1511 from its previous version I.e Configmgr 2012 R2 SP1 ,along with it,there are also newly added SQL views that help you to generate reports for the newly added features.So for this,we need to have that information…
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 if you compare with default compliance report. In this post, I have made some changes and bring additional report called patch progression report (have added installed patches to the report) to show how patches each PC is missing and installed with client information like OS,Last…
The latest version of Configuration manager which is V1511 (YY/MM) RTM for December 2015 from Microsoft is now available for download and ready to install to production Environment. We call this version as System Center Configuration Manager current branch (CB) and Microsoft has updated TechNet documentation on December 8 (Yesterday) for this version .The documentation is Applies To: System Center Configuration Manager (current branch) https://technet.microsoft.com/en-us/library/mt346023.aspx As you all know by now that ,going forward ,Microsoft do not use year or product identifier like previous versions 2003,2007 and 2012 and it supports incremental product updates (no more service packs or cumulative…