By Garth Jones
In one of my previous blog posts, I talked about 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 to track 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 backup 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.