Create a Custom Report in SCCM
First create a SQL query, such as a custom hardware report in the SQL Management Studio.
Next open SCCM console and click on the reporting tab
Click on create report and select SQL base reports
Click next twice and click close, this will bring up Report Builder 3.0.
Click table to enter a new SQL query
Within Report building select table and create a new dataset.
Select use current Windows user when login pop-up, login with your service account or account that has rights to create reports
Select edit as text to enter SQL
Click on run to ensure SQL query works and you see result in pane below
Click next to continue
Select the available fields and drag them to Values fields, below I highlighted all fields and move to Value fields.
Click next to continue
Select a theme for report and click finish.
Close the X in upper right corner and save the report
To run the saved report, go to monitoring then reports
Expand the reports and select Hardware – General
Inside Hardware General then Custom Hardware Inventory
Please check out the SCCM Sql Queries Tab for some SQL queries for your SSRS Reports.