Useful Reports

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.

1

2

3

The Advertisement ID in the Task Sequence section is a link to the second report.

4

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
<DataSources>
</DataSources>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>
<DataSourceName></DataSourceName>

———- TASK SEQUENCE EXECUTION DETAIL.RDL
<DataSources>
</DataSources>
<DataSourceName></DataSourceName>

I have made the site code in the RDLs “XXX” and the reporting server name “server.domain.name” for easy search/replace…

task-sequence-execution-detail

simplified-deployment-report

Some of the queries in the reports use the ipstringtonumber and numbertoipstring functions…

https://sccmnotes.wordpress.com/2016/07/22/ipstringtonumber/

https://sccmnotes.wordpress.com/2016/07/22/numbertoipstring/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s