Howto Remove ConfigMgr_SiteCode.Old.0 Folders in SCCM Reporting Services

Reporting service Point in SCCM can be really handy sometimes, when you need to lookup something in a AD domain. Specially when you will see how an deployment has been running.

I discover something strange on a customer’s reporting services. The SSRP Service has been created Loads of Folders with name ConfigMgr_SiteCode.OLD.0 And when I tried to Select every folders and remove them, the internet explorer hanged itself.

Before:

old reports

So I created this powershell script to remove all OLD folders.

<#
.SYNOPSIS
Remove SCCM Reporting Services Folders ConfigMgr_SiteCode.OLD.*

.DESCRIPTION
This Script will help us to remove SCCM Reporting Services folder, that has name ConfigMgr_SiteCode.OLD.*

.EXAMPLE
.\RemoveOldReportingServicesFolders.ps1

Enter the ConfigMgr Site Server Name:

Enter the Sitecode:

.NOTES

.LINK
#>

# Get data
$ConfigMgrServerName = Read-Host("Enter the ConfigMgr Site Server Name")
$ConfigMgrSiteCode = Read-Host("Enter the sitecode")

# Connect to Reporting Services
$URL = ("http://" + $ConfigMgrServerName + "/ReportServer/ReportService2005.asmx?WSDL")
$ConnectToReportService = New-WebServiceProxy -Uri $URL -UseDefaultCredential

# Get all report folders
$RemoveOldReportFolders = $ConnectToReportService.ListChildren("/", $True)

# Remove all Folder with name ConfigMgr_SiteCode.OLD.*
$RemoveOldReportFolders | Where-Object {$_.Name -like ("ConfigMgr_" + $ConfigMgrSiteCode + ".OLD.*")} | ForEach-Object {$ConnectToReportService.DeleteItem($_.Path); "Deleted Folder: " + $_.Name}


The Result:
old reports after

1 thought on “Howto Remove ConfigMgr_SiteCode.Old.0 Folders in SCCM Reporting Services”

  1. BOFHXX skriver:

    Thanks for this. Saved me a lot of time (Working on SCCM 2012R2)

Lämna ett svar

E-postadressen publiceras inte. Obligatoriska fält är märkta *

SCCM 2012 R2 CU2 is now available

Microsoft has released Cumulative Update 2 for System Center Configuration Manager 2012 R2. It is an optional update (that does not affect the product support lifecycle) that contains fixes for

Howto – Connect to Configuration Manager 2012 from Powershell

Hi, Emil here. Have you ever wonder howto connect to a configuration manager 2012 site from Powershell? Okay, follow the steps below to success: Requirements: SCCM 2012 Console Powershell 3.0

Deploying Windows To Go

Windows To Go lets you to boot and run Windows 8 (Enterprise) from a USB stick as well as allowing you to connect to your corporate infrastructure from that image.