In one of my previous blog posts, I discussed how to back up a custom ConfigMgr report. In that blog post, I said that that process was good for a handful of reports, but that you need to use PowerShell or something else to back up all of your custom ConfigMgr reports.
In this blog post, I will save you the time of tracking down a PowerShell script to back up all of the reports on your ConfigMgr Reporting Point.
The script that I use to back up all of my ConfigMgr reports was created by Donabel Santos @sqlbelle. She is a SQL MVP and author of SQL Server 2012 with PowerShell V3 Cookbook. On her blog, you will find a post entitled, “How to Download All Your SSRS Report Definitions (RDL files) Using PowerShell.”
1. Copy and paste the whole script into PowerShell ISE.
2. Edit Line 4, so that your Reporting Point Server is listed. Keep in mind that if you have an SSRS instance, your URI will need to include your instance name too. My Reporting Point is on cm-cas-rs1. I highlighted the line you need to edit.
3. Ensure that you have a C:\temp directory.
4. Execute the script.
This script is great, but it does have a minor downside. The downside is that it will also back up all of your default ConfigMgr reports too, but IMO, I would rather have more than less! By doing this, I’m assured that I’ll have all of them, plus backing up all of the RDLs for my site is less than 65MB total.
If you have any questions, please feel free to contact me at @GarthMJ.
See how Right Click Tools are changing the way systems are managed.
Immediately boost productivity with our limited, free to use, Community Edition.
Get started with Right Click Tools today: