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…

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…
Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

Long back created a report for the monthly Patch statistics which can be found in http://www.windows-noob.com/forums/index.php?/topic/1764-patch-management-report-in-sms-2003/#entry6281 Below all the reports have been created using the last state messages.Even you can create different type of quiries based on this. I was referring to the Patch process and found an image which gives the statistics for the…