SCCM Report Manager Tool for managing SCCM Reports

We developed an SCCM Report Manager tool using Powershell to manage your reports on an SCCM Reporting Point.

SQL Reporting Services can be time-consuming when you need to download, upload or change data source on multiples reports. If you purchase one of our reports or our Complete Report Bundle, you had to upload every report and change their data source one-by-one. This tool is then a must if you need to manage multiple reports.

Based on your SCCM Reporting Point and SCCM site code, the tool allows to :

Upload multiple reports from a specific folder — Useful if you have multiple RDL files to upload at once
Download all report from a specific SSRS folder — Useful if you have multiple custom reports and are doing a migration to a new reporting point
Change data source of all reports from a specific SSRS folder — Useful if you upload multiple new reports and need to change their data sources

[alert type=”info” close=”false” heading=”Script requirements”] The script needs PowerShell 2.0 and has been tested on SQL 2012 and SQL 2016 Reporting Point.[/alert]

The SCCM Report Manager can be downloaded from my Github page. Feel free to leave your comments and suggestions in the comments section.

SCCM Report Manager Tool Screenshots

[ratings] [share title=”Share this Post” facebook=”true” twitter=”true” reddit=”true”]

Benoit Lecours

Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 5 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intunes deployments.

5 Comments on “SCCM Report Manager Tool for managing SCCM Reports”

doug

01.28.2021 at 7:11 PM

The Tehnet Gallery link no longer works. Where can this script be downloaded from now? It would be very useful to have.

Log in to Reply

Jonathan Lefebvre
01.29.2021 at 3:06 PM

Thanks for pointing that out. I modified the link to GitHub.

here it is as well https://github.com/prae1809/PowerShell-Scripts/tree/master/SCCM%20Reports%20Manager%20Tool

Jonathan

ben

04.17.2019 at 4:05 AM

Great tool – it would be really useful if it did a comparison as well…
i.e point to old reporting server – list the folders and number of reports, and compare to the “new” reports server…. help to identify missing custom reports