Use My Subscriptions (Native Mode Report Server)
Updated: July 1, 2016
Applies To: SQL Server 2016
The Reporting Services Web portal includes a My Subscriptions page that organizes all of your subscriptions into one place. You can use My Subscriptions to view, modify, enable, disable, and delete existing subscriptions. However, you cannot use it to create subscriptions. My Subscriptions shows only the subscriptions that you create. It does not list subscriptions that are owned by other users, even if you are added as a subscriber to those subscriptions, nor does it show data-driven subscriptions.
|Applies to: Reporting Services Native mode|
The search field will dynamically filter the list of subscriptions as youYou cannot search for subscriptions by name, nor can you search for subscriptions based on trigger information, status information, and so forth. For more information, see Create and Manage Subscriptions for Native Mode Report Servers.
- Open the Reporting Services Web portal.
- Click settings in the toolbar.
- Click My Subscriptions.
For more information, see Reporting Services Web portal.
The following PowerShell script will return the list of subscriptions and subscription properties for the current user. For more information, see ReportingService2010.ListMySubscriptions Method.
#server - all subscriptions of the current user at the given server or site $server="[server name]/reportserver" $rs2010 = New-WebServiceProxy -Uri "http://$server/ReportService2010.asmx" -Namespace SSRS.ReportingService2010 -UseDefaultCredential; $subscriptions=ListMySubscriptions(ItemPathOrSiteURL) $subscriptions | select Path, report, Description, Owner, SubscriptionID, lastexecuted,Status #uncomment the following to list all the subscription properties #$subscriptions