Master Patch Management Report
Patch Management Solution 7.5, 7.6, 8.0, 8.5 and 8.6
This Master Patch Management Report (SQL Query - Ultimate Patch Report_5 - All Clients & Bulletin-Update Details.txt) applies to versions earlier than ITMS 8.0.
Caution: Putting this report into a Custom SQL Report to be ran on the Console may time-out due to the length of the returned data. The parameters on the report could be modified to a specific Filter or Target to reduce the rendering time, but running this in SQL Server Management Studio directly would be the ideal method of execution.
Advisory: Found the report fails to render in ITMS 8.0 due to changes in database schema. Attached updated report to run in ITMS 8.0: SQL Query - Ultimate Patch Report - ITMS 8.0.sql.
Additionally, added changes presented in ITMS 8.0 HF3 required an updated script. Please review the attached SQL Query - 80-HF3-Ultimate Patch Report_5 - All Clients & Bulletin-Update Details.txt to review in SQL Server Managment Studio, or import the attached .xml to view the report in the Console.
For 8.5 and 8.6 just import the xml file for report generation.