Sharing a couple of reports, what I call the “Simplified Deployment Report”, and then a linked report “Task Sequence Execution Detail.”
I’ve worked on the “Simplified Deployment Report” for a few years, starting back with SCCM 2007. It’s sort of like a one stop shopping for information about a single computer; domain info, inventory dates, policy request, boundaries, collections, etc., anything I want to know about a computer and am too lazy to find it in the console.
I’m breaking the pictures into pieces, so I can try to format it better.
The Advertisement ID in the Task Sequence section is a link to the second report.
In the RDLs, the DataSources and DataSourceName sections will need to be edited to point to the report server:
C:\>find /i “datasource” *.rdl
———- SIMPLIFIED DEPLOYMENT REPORT.RDL
———- TASK SEQUENCE EXECUTION DETAIL.RDL
I have made the site code in the RDLs “XXX” and the reporting server name “server.domain.name” for easy search/replace…
Some of the queries in the reports use the ipstringtonumber and numbertoipstring functions…