Export (0) Print
Expand All

Use My Subscriptions (Native Mode Report Server)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Reporting Services Report Manager includes a My Subscriptions page that organizes all of your subscriptions into one place. You can use My Subscriptions to view, modify, and delete existing subscriptions. However, you cannot use it to create subscriptions.

Applies to: Reporting Services Native mode

Within My Subscriptions, you can sort subscriptions by folder, report, description, trigger, last run, or status. All values are sorted alphabetically except for Last Run, which is in chronological order.

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.

You 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.

My Subscriptions is available through Report Manager. To access My Subscriptions, click My Subscriptions on the Report Manager global toolbar.

PowerShell related content

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft