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=”CatapultSystems.com” url=”https://www.catapultsystems.com/blogs/software-update-compliance-for-each-computer-in-a-collection”] 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.
[/read-more-redirect]