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.


The report file (Compliance 5 – Computers in a Collection.rdl) can be found 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.