Month: January 2022

Backup SSRS Reports

by

If you need to backup your SSRS reports you can download each report individually, or use PowerShell to backup all of them quickly.

The information in this post was taken from the following articles:
https://www.recastsoftware.com/resources/how-do-you-backup-all-of-your-custom-configmgr-reports/
and
http://www.sqlmusings.com/2011/03/28/how-to-download-all-your-ssrs-report-definitions-rdl-files-using-powershell/

The website that the Recast article referrers to is no longer available and is only accessible via the web archive link given in the article. This post is so the script is easily available for later use.

The script has been updated and is available on GitHub.

The script requires two parameters, the SSRS FQDN, and the directory save the reports to. If the directory doesn’t exist, the script will create it.

The script assumes that HTTPS has been enabled on the SSRS site. If HTTPS has not been enabled, the script will need to be modified to switch back to HTTPS.

A progress bar is used to show progress.

Report backup in progress.
Reports have been backed up to the location passed to the script.

Working with ConfigMgr folders

by

When working with ConfigMgr and PowerShell you’ll need to interact with folders.

  • Get folder
  • Create folder
  • Delete folder

Pre ConfigMgr 2111

The folder structure can be accessed using the site code as a PSDrive. For example, PS1:\.

Each workspace and node have different folder structures within them. To see the options use the command below.

The folder structure used in PowerShell doesn’t always match the folder structure in the console. Generally, the console shows the items using the plural of the word, while PowerShell uses the singular of the word. In the console it’s Applications, while in PowerShell it’s Application.

List folders

To list a folder use the following:

Create folder

To create a folder use the following:

Remove folder

To remove a folder use the following:

Post ConfigMgr 2111

ConfigMgr added four new cmdlets to deal with folders:

To be continued…