Month: May 2011

Posted on May 17, 2011 by | 2 Comments | 5,210 Views
Create New SCCM collection and paste the below query into it. select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7%" and SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" Also need report :look at here http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx
Read more »

Posted on May 16, 2011 by | 0 Comments | 1,027 Views
Here is another patch statistics report for SCCM 2007 environment with summary of patches that are deployed within month (30 days) with different column. select 'Total number of active patches within 30days:', COUNT(distinct Title) AS 'Count' FROM v_GS_PatchStatusEx WHERE (DATEDIFF(Day, LastStatusTime, GETDATE())) <=30 UNION select 'Percent sucessfully installed', round(100.0*COUNT( case when LastState=107 or LastState=105 then ResourceID…
Read more »