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

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

Leave a Reply

Din e-postadress kommer inte publiceras. Obligatoriska fält är märkta *

Related Post