How Do You Backup All of Your Custom ConfigMgr Reports?

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.

How Do You Backup All of Your Custom ConfigMgr Reports-PowerShell Script 

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.

Showing 2 comments
  • Paul Edwards
    Reply

    Hi Garth,
    I am having to create a new Reporting Services Point on a different server. I think I know what to do to uninstall the RSP, move the databases, reconfigure SSRS and reinstall the RSP.
    What I am not clear on is whether this will also mean that our existing custom reports (and slightly ‘tweaked’ default reports) will also be available on the new RSP.
    Or will I have to recreate them again? If so, is there an easy way to do this with a script? Or will I have to re-add them all individually from the backup location done using your script?

    • Garth Jones (Admin)
      Reply

      I would NOT uninstall and move the db, I would create new db/SSRS site. If you move the db then you will have to deal with backing up the SSRS certs and restoring them.

      The script within the blog will download all of you reports, including the default CM ones! You will then need upload them to your new reporting point. Hopefully there are only a few custom ones as this will be a manual process. Then you will need to change the data source too. https://www.enhansoft.com/how-to-upload-a-ssrs-report-and-change-its-data-source/

      Make sense??

Leave a Comment

Share via
Copy link