Creating SCCM Reports using Bold Reports

Overview

System Center Configuration Manager (SCCM) traditionally uses SQL Server Reporting Services (SSRS) to generate reports. These SSRS reports are built using a system data source that connects directly to the SCCM database.

Bold Reports fully supports this approach, allowing you to create SCCM reports by connecting to the same system data source used in SSRS. This makes it possible to design, deploy, and manage SCCM-style reports directly within Bold Reports.

Can Bold Reports Be Used to Create SCCM Reports?

Yes. SCCM reports are essentially standard SSRS reports that use the SCCM SQL database as a system data source. Since Bold Reports also supports system data sources, you can create SCCM reports using the same approach.

This means that SQL queries, datasets, and report layouts used in SSRS can also be recreated or redesigned in Bold Reports.

Prerequisites

Before creating SCCM reports in Bold Reports, ensure that you have:

• Access to the SCCM SQL Server
• Database credentials with query permissions
• SCCM database name (commonly CM_)
• Bold Reports Server / Report Designer installed

Step-by-Step: Creating SCCM Reports in Bold Reports

Step 1: Identify the SCCM System Data Source

In SSRS, SCCM reports typically use a predefined shared data source such as:

• Data source type: Microsoft SQL Server
• Connection string: Server=<SCCM_SQL_Server>;Database=CM_

You will replicate this data source in Bold Reports.

Step 2: Create a New Data Source in Bold Reports

1. Open Bold Reports Server or Report Designer.
2. Navigate to Data Sources → Add Data Source.
3. Choose SQL Server as the provider.
4. Enter the same connection string used for SCCM SSRS reports.
5. Click Test Connection.
6. Save the data source. For more information, see: Add or Create Data Sources

Step 3: Create the Dataset

1. Open Bold Reports Server or Report Designer.
2. Click Add Dataset.
3. Select the data source created earlier.
4. Enter your SCCM SQL query.
5. You can reuse queries from existing SSRS SCCM reports as a reference.
6. Preview the dataset to verify that data is returned correctly. For more information, see: Add or Create Datasets

Step 4: Design the Report Layout

Using the Bold Reports Designer, you can:

• Add tables, charts, matrices, gauges, and parameters
• Format data such as compliance levels, software deployment status, and device collections
• Apply grouping, sorting, and filtering

Bold Reports supports all SSRS-style report design elements. For more information, see:

• Design RDL Report in Web Report Designer
• Bold Reports Designer

Step 5: Publish and Preview the Report

1. Save the report.
2. Publish it to Bold Reports Server.

For more information, see:

• Publish Report in Report Designer
• Preview a Report

See Also

• Step-by-Step SCCM Report Creation using Report Builder - System Center Dudes