A month ago ,18th Feb 2016 ,Microsoft released Configmgr 1602 (YYMM) for Technical Preview 4 with some exciting features and updates . After a month later ,Yesterday i.e 18th March 2016 ,Microsoft announced of another update 1603 ((Note : this is only for Technical preview but not for Current Branch V1602,Production version)) for Technical Preview 4 with some new features and fixed 2 voice items that were raised through Configmgr user Voice forum. Features included in this update are: List View for Applications in Software Center – In the Software Center Applications tab, users now have the option to switch…
Author: Eswar Koneti
I had requirement from team to find out the clients that have one application (example Java) with one version installed and exclude clients that have multiple versions with same application installed. Lets take simple example . I have clients CLN01,CLN02,CLN03 and CLN04 and they have different versions of Java application installed on them. PC Name Application Version CLN01 Java 7 Update 45 8.0.005 CLN01 Java(TM) 6 Update 37 6.0.370 CLN01 Java 7 Update 80 7.0.450 CLN02 Java 7 Update 45 8.0.005 CLN02 Java(TM) 6 Update 37 6.0.370 CLN03 Java 7 Update 80 7.0.450 CLN04 Java 7 Update 45 8.0.005 Now…
One of my Blog reader has posted a comment asking for ‘How to create Collection to pop-up clients from multiple Collections start with ABC% ‘ ? ABC is the Collection Name starts with. If you want to create a collection to see all clients from different Collections and the Collection Name starts with ABC .How do you get this done ? For this requirement, You Cannot use Include collection as this is not Dynamic .If you choose to go with Include collection (which is Static) ,you cannot get the clients from collections that will be created in the…
There was a question raised by someone on MyItform list ,asking for ‘is there a way to get superseded patch list’ for all windows 7”. when I read the question ,I was thinking ,we can get this using the default reports but when I check the default reports,there is no such report that match this requirement . So ,I sat for sometime in the lab ,started writing the SQL Query ,found something . So thought of writing this blog post that helps others who are in similar needs. If you want to know particular patch (ex:Cumulative Update for Windows…
Microsoft is doing fabulous job on System Center configuration manager product by enhancing ,adding the new features ,update the existing features in the form of Technical preview’s before making them to Production version and they listen the ideas ,suggestions reported through Configuration manager User Voice https://configurationmanager.uservoice.com/forums/300492-ideas A day before (18th Feb 2016) ,Microsoft released Configmgr 1602 (YYMM) for Technical Preview 4 which is latest version (Note : this is only for Technical preview but not for Current Branch V1511,Production version) with some exciting features and updates to the existing features that were in 1601. One of the most exciting feature…
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’…
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 =…