Year: 2016

SCCM Configmgr SQL Report get list of machines with one Version of application and exclude other versions

Posted on March 17, 2016 by | 0 Comments | 5,724 Views
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…
Read more »
SCCM Configmgr 1602 Available for Technical Preview 4

Posted on February 19, 2016 by | 0 Comments | 232 Views
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…
Read more »
SCCM list all default and Custom reports with created by, modified by, data source , Path

Posted on February 10, 2016 by | 0 Comments | 2,298 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 | 54 Comments | 19,242 Views
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…
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 | 837 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 | 40,581 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 »