Create Report in SCCM with Computer Information

This how-to shows how to create a report in System Center Configuration Manager with computer information like serial number etc.

Open the Management Console. Navigate to Reporting. Right click on Reports and select New –> Report.  image
Give it a name.

Select the category under which the report will be displayed. (eg Hardware – General)

Click on: Edit SQL Statement.

Paste the Statement(displayed and the bottom of this blog post.) in the SQL Statement box.

Remove the default statement.

Run the report and it will display al kind off useful stuff. Like the Serial Number. Knipogende emoticon image