Powershell Script to export Subscriptions in SSRS -2

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

# Load the ReportingServices2010 assembly [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.ReportingServices2010") | Out-Null # Connect to the Report Server $rs = New-Object Microsoft.SqlServer.Management.ReportingServices2010.ReportingService2010 $rs.Credentials = Get-Credential $rs.Url = "http://<ReportServerName>/ReportServer/ReportService2010.asmx" # Get a list of all subscriptions $subscriptions = $rs.ListSubscriptions("/") # Export each subscription to a CSV file ForEach ($subscription in $subscriptions) { # Get the details of the subscription $details = $rs.GetSubscriptionProperties($subscription.SubscriptionID) # Write the subscription details to a CSV file $details | Export-Csv "Subscription_$($subscription.SubscriptionID).csv" -NoTypeInformation }

This script first loads the ReportingServices2010 assembly and then connects to the Report Server using the URL and credentials provided. It then retrieves a list of all subscriptions and loops through each one, exporting the subscription details to a separate CSV file named Subscription_<SubscriptionID>.csv.

Note that you will need to replace the URL of the Report Server in the script with the URL of your own Report Server, and you will need to provide your own credentials when prompted.