Powershell Script to export Subscriptions in SSRS - 3

Here is a PowerShell script that can be used to export subscriptions in Microsoft SQL Server Reporting Services (SSRS):

# Load the ReportingServices libraries [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.ReportingServices") # Connect to the SSRS server $ssrsServer = "ServerName" $ssrs = New-WebServiceProxy -Uri "http://$ssrsServer/ReportServer/ReportService2010.asmx?WSDL" -Namespace SSRS.ReportingService2010 -UseDefaultCredential # Get a list of all subscriptions on the SSRS server $subscriptions = $ssrs.ListSubscriptions("/") # Export the subscriptions to a CSV file $subscriptions | Select-Object Path, Report, EventType, @{Name="DeliveryExtension";Expression={$_.Extension}}, @{Name="Description";Expression={$_.Description}} | Export-Csv "Subscriptions.csv" -NoTypeInformation # Disconnect from the SSRS server $ssrs = $null

This script starts by loading the ReportingServices libraries and connecting to the SSRS server using the New-WebServiceProxy cmdlet. It then retrieves a list of all subscriptions on the SSRS server using the ListSubscriptions method of the $ssrs object.

The list of subscriptions is then exported to a CSV file using the Export-Csv cmdlet. The properties that are exported include the path of the report, the name of the report, the type of event that triggers the subscription, the delivery extension used to send the report, and the description of the subscription.

After exporting the subscriptions, the script disconnects from the SSRS server.