Powershell script to list all the SharePoint 2013 integrated SSRS 2012 subscription details

MSDN reference

Using PowerShell script we can find all the SharePoint 2013 integrated  SSRS 2012 subscription details:

Script:

# Parameters
# server – server and instance name (e.g. myserver/reportserver or myserver/reportserver_db2)

Param(
[string]$server,
[string]$site
)

$rs2010 += New-WebServiceProxy -Uri “http://$server/_vti_bin/ReportServer/ReportService2010.asmx” -Namespace SSRS.ReportingService2010 -UseDefaultCredential ;
$subscriptions += $rs2010.ListSubscriptions($site); # use “/” for default native mode site

Write-Host ” ”
Write-Host “—– $server’s Subscriptions: ”
$subscriptions | select Path, report, Description, Owner, SubscriptionID, lastexecuted, Status

powershell c:\scripts\ListAll_SSRS_Subscriptions.ps1 "[server]/_vti_bin/reportserver" "http://[server]" 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s