SCCM
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. |  |
| 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.  |
 |
