This is a modification of the default report Compliance 5 – Specific Computer, but it combines the result for each computer in a collection.  The report can get quite long, however, it is a much better than running the default report for each computer in a collection, exporting the data to Excel, and manually combining it.


div class=”ExternalClassE5EB0BFF002042829AB1629955D63C4E”>


The report file (Compliance 5 – Computers in a Collection.rdl) can be found [read-more-redirect urltext=”” url=””] on my GitHub repo.

Perry Smith gets the kudos for twisting my arm enough to develop the report.  Actually it was a lot easier than I anticipated.

Kudos also go to Garth Jones for his post on @UserSIDs which is tremendously helpful in using Microsoft SQL Server Management Studio for T-SQL development  of SQL Reporting Services reports.


Software Update Compliance for Each Computer in a Collection
Tagged on: