Skip to main content

Report Builder

SAMPLE DATA
SELECT-only account required. The SQL account used here must have read-only (SELECT) permission on the site database. This application never issues INSERT, UPDATE, DELETE, TRUNCATE, ALTER, CREATE or DROP statements against a Configuration Manager database, and never creates indexes on it.

SSRS Report Definition (RDL) Generator

Produces an RDL report definition containing read-only SELECT queries against supported SCCM views. No server names or credentials are embedded in the file.

Charts, 12-month trend, deployment summary, failed KB and error-code sections.

The download is the report definition validated in a live Configuration Manager Current Branch 2509 environment (site version 5.0.9141.1000, Report Builder 15.x, SSRS 2016–2022 and Power BI Report Server, RDL 2016/01 schema). Layout, parameters and field definitions are byte-for-byte the definition that imported and executed successfully; only the dataset queries have been tuned for very large collections such as All Workstations. Each heavy dataset now materialises collection membership into an indexed tempdb working table and pre-aggregates v_Update_ComplianceStatusAll to one row per device before joining, instead of counting DISTINCT across the expanded view — that is what caused execution timeouts on estate-wide collections. Dataset timeouts are raised to 900 seconds and every query uses OPTION (RECOMPILE). Nothing is written to the site database (tempdb working tables only), no custom views or stored procedures are required, and the data source is emitted as a shared data source reference by name so you bind it to your existing ConfigMgr data source after import.

Import the file through Configuration Manager reporting or the SSRS portal, then bind it to your existing shared data source. The reporting account only requires db_datareader on the site database.

Before uploading: make sure the file is named exactly SCCM-Patching-Dashboard.rdl. If your browser saved it as SCCM-Patching-Dashboard (3).rdl, rename it — SSRS derives the catalogue item name from the file name and rejects spaces and brackets with “the name of the item … is not valid” (URL-encoded characters).