This is continuation to the post avilable here on http://eskonr.com/2010/03/monthly-patch-statistics-reports-to-show-up-to-the-management-in-a-simplified-manner/ Report posted on the above link doesnt give you the required information what it gives in SMS 2003 since some of the columns in have been changed i.e product has blank value from v_GS_patchstausEX view etc in sccm 2007. Below is the modified report that…
SLA report for SCCM Software Distribution

Have you been asked by your boss saying can you send me the report for the applications that are deployed last month with Success rates /failures? You will be wonder after looking at the success rate 🙂 and start troubleshooting why is this . We will be deploying number of applications per day using SCCM…

Recently have a requirement to uninstall all old adobe versions and install the new on.Looking for something which can be done Via but i found the below method is simple that can remove all the older applications and instal the new one(which can be done Via TS by adding two TS actions one with removal…

I was thinking to share something interesting with you all and it is very useful at times when you are dealing with installation or Uninstallation of applications ,but due to other priority works,i could not post it early. We recently started application deployment (running on SCCM 2007) for new client and lot of applications are…

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

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…