CODEWITHSUNDEEP
sharepointreporting-services
Kulis
Kulis

Reputation: 1010

List of all subscription

How to check all report's subscriptions on Sharepoint 2010?

I know only how to check subsciption on specific report:

enter image description here

Upvotes: 2

Views: 674

Answers (1)

David Drever
David Drever

Reputation: 801

Unfortunately, there is no way way for you to do this from the GUI. You are going to have to break out PowerShell to get this information.

NOTE: I haven't tested this code, kinda writing it from the hip, but the gist should be able to help you out.:

$spWeb = Get-SPWeb <Site reports are contained in>
$spRepList = $spWeb.Lists["<List containing reports Name>"];
#Get all files
$spFileList = $spRepList.Files;

foreach($spFile in $spFileList)
{
   #determine if the file is a report or a regular document
   if($spFile.URL -like "*.rdl")
   {
      $reportServiceProxy = New-WebServiceProxy -URI <url to the reporting web service> -Namespace <Namespace of the service> -UseDefaultCredentials
      $subscriptionList += $reportServiceProxy.ListSubscriptions($site);

      #From here you can write to a file or write to the screen.  I will let you decide
      $subscriptionList | select Path, report, Description, Owner, SubscriptionID, lastexecuted,Status | where {$_.path -eq $spFile.URL}
   }
}

Hope this helps.

Dave

Upvotes: 2

Related Questions