Creating a ConfigMgr Report from a SQL Query
Here are the steps required to put your favorite SQL query into a ConfigMgr Report.
Open Report builder.
You can right click a report and go to edit to open
Click top left button and select New
Select Table or Matrix Wizard
Create a dataset, Next
When prompted, you can connect with the current windows user
On the Design a query, select “Edit as Text”, paste your query, and click next
Drag all available fields to the values box and ensure they are in the order that you want and click Next
Click next through the layouts and it’ll finish
Once back in report builder you can add a title and clean up the column names and width as needed
Once complete, click save it to your SRS site (Under ConfigMgr_XXX)
You can create a Custom folder or select an existing folder that makes sense like “Operating System” or “Site – Client Information”