• Article

How to Create Configuration Manager Reports

 

Updated: January 1, 2014

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

You can create two types of report directly from the Configuration Manager console:

  • Model-based report – Allows you to create a report based on a Reporting Services model and select the attributes to be included with Report Builder.

  • SQL-based report – Allows you to create a traditional report based directly off the database views by using SQL statements and stored procedures.

To create a new model-based report

  1. In the Configuration Manager console, click Monitoring.

  2. In the Monitoring workspace, expand Reporting, and then click Reports.

  3. In the Home tab, in the Create group, click Create Report.

  4. On the Information page of the Create Report Wizard, configure the following settings:

    - **Type:** Select **Model-based Report** to create a report in Report Builder by using a Reporting Services model.

- **Name:** Specify a name for the report.

- **Description:** Specify a description for the report.

- **Server:** Displays the name of the report server on which you are creating this report.

- **Path:** Click **Browse** to specify a folder in which you want to store the report.

  5. On the Model Selection page of the wizard, select an available model in the list that you use to create this report. When you select the report model, the Preview section displays the SQL Server views and entities that are made available by the selected report model.

  6. On the Summary page of the wizard, review the settings. Click Previous to change the settings or click Next to create the report.

  7. On the Completion page of the wizard, click Close to exit the wizard, Report Builder now opens where you can configure the report settings. Enter your user account and password if you are prompted, and then click OK. If Report Builder is not installed on the computer, you are prompted to install it. Click Run to install Report Builder, which is required to modify and create reports.

  8. In Report Builder, create the report layout, select data in the available SQL Server views, add parameters to the report, and so on. For more information about using Report Builder to create a new report, see the Report Builder Help.

  9. Click Run to run your report. Verify that the report provides the information that you expect. Click Design to return to the Design view to modify the report, if needed.

  10. Click Save to save the report to the report server. You can run and modify the new report in the Reports node in the Monitoring workspace.

To create a new SQL-based report

  1. In the Configuration Manager console, click Monitoring.

  2. In the Monitoring workspace, expand Reporting, and then click Reports.

  3. In the Home tab, in the Create group, click Create Report.

  4. On the Information page of the Create Report Wizard, configure the following settings:

    - **Type:** Select **SQL-based Report** to create a report in Report Builder by using SQL statements.

- **Name:** Specify a name for the report.

- **Description:** Specify a description for the report.

- **Server:** Displays the name of the report server on which you are creating this report.

- **Path:** Click **Browse** to specify a folder in which you want to store the report.

  5. On the Summary page of the wizard, review the settings. Click Previous to change the settings or click Next to create the report.

  6. On the Completion page of the wizard, click Close to exit the wizard, Report Builder now opens where you can configure the report settings. Enter your user account and password if you are prompted, and then click OK. If Report Builder is not installed on the computer, you are prompted to install it. Click Run to install Report Builder, which is required to modify and create reports.

  7. In Microsoft Report Builder, create the report layout, select data in the available SQL Server views and add parameters to the report, and so on. For more information about using Report Builder to create a new report, see the Report Builder Help.

  8. Click Run to run your report. Verify that the report provides the information that you expect. Click Design to return to the Design view to modify the report, if needed.

  9. Click Save to save the report to the report server. You can run and modify the new report in the Reports node in the Monitoring workspace.