This Master Patch Management Report (SQL Query - Ultimate Patch Report_5 - All Clients & Bulletin-Update Details.txt) displays the following columns:
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.