If you search on the web for Configmgr patch compliance report ,you get various links that talk about compliance reports ,you utilize them to start working on the customized report the way you want but i was looking for something that give me the overall compliance status for each month ? search did not provide me much useful information on this ,I then decided to create and share to public. How do you monitor the overall patch progress for the current month and its previous months ? let say,for the current month,compliant machines are 500(which have got all approved patches) and…
Author: Eswar Koneti
Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting select cs.Name0 [Computer name],COUNT(*) as [No of Times] from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs where FileName like '%.mdf%' and SF.ResourceID=cs.ResourceID group by cs.Name0 order by 2 desc
Long ago,posted Configmgr SP1 SQL Views in spreadsheet which you can download it via post http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/. SQL Views are very useful while working with reports and it saves lot of time in searching the particular information if you are unsure where it resides. SQL Views provides the information help you in creating custom reports, determine which configmgr 2012 R2 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them. With the release of Configmgr 2012 R2,there has been some SQL Views…
There was a question in forum list about how to get count of clients by its status (active,obsolete etc). I looked at it if there is any way to get it without report but No. In Configuration Manager 2007,to know the count of Computers from collection,You right click on collection,click show Count will give us the information but in Configmgr 2012,this is not possible until you develop some custom tools to get this.By default ,You can only see the total number of clients Count and members visible but not how many active,obsolete etc . I created simple report…
Second Tuesday of every month called Microsoft patch Day 🙂 Patches get released and configmgr* guys busy in testing ,moving them to production. As usual, I have Downloaded the patches,added to the package,deployed to Distribution Points ,all returned success (Decompressed the PCK successfully).Until here Good. While testing the patches on one of the server,it just stands at downloading /Preparing for installation for quite long but nothing happens.Huh ? (login with mstsc /admin) ok,start with basic troubleshooting by looking at contentTransfermanager.log and datatransferservice.log because these two logs plays the role whether the client attempts to download content or not ContentTransferManager.log--> logs…
We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running. Being configmgr admin,you are responsible to maintain clients levels same as that of your site server.i created SSRS Report and linked report to list down all the client versions, Description of Version name and its count. Use this below SQL query to count the Client…
Few Days ago,Microsoft released Cumulative Update 3 (supersedes Cumulative update 2 ) for Configuration Manager 2012 SP1 which has around 18 fixes related OSD,Powershell,Software Distribution etc. More about the hotfix and download refer http://support.microsoft.com/kb/2882125 Installation of Cumulative Update 3 on Configurations manager SP1 is straight forward.you would need to follow the steps,next,next ,done. This Cumulative Update contains updates for CAS,Primary site(both Stand alone,Hierarchy),Secondary Site,SMS Provider,Configmgr Console and Configmgr Client. I have updated my Lab with Cumulative Update 3 today,saw couple of packages gets created with this update. Note:Close the Configuration Manager Administrator Console before you install this update. After the…
With the default report,you can get Count or list of PC’s from domain Eg: Computers in a specific workgroup or domain. If you want to know the count of PC’s with specific role like standalone workstation a.k.a Workgroup computers,member workstation,member server,standalone server etc,use the below report . I use property called DomainRole0 from V_GS_Computer_system view with case statement. select "Role"= case domainrole0 when 0 then 'Standalone Workstation' when 1 then 'Member Workstation' when 2 then 'Standalone Server' when 3 then 'Member Server' when 4 then 'Backup Domain Controller' when 5 then 'Primary Domain Controller' else 'No' end, Count(*) [Total] from…