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.
We developed a Powershell script to manage your reports on an SCCM Reporting Point.
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
Important InfoThe script needs PowerShell 2.0 and has been tested on SQL 2012 and SQL 2016 Reporting Point.
The SCCM Report Manager tool can be downloaded from my Technet Gallery page. Feel free to leave your comments and suggestions in the comments section.
SCCM Report Manager Tool Screenshots
Share this Post
Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 4 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.