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

Data Source connection should already be selected, 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”