How to view a report subscription history

• Casper101

  Hall of Fame

  Points: 3903

  More actions

  March 4, 2010 at 6:56 am

  #217478

  Hi,

  Is is possible to see the history of a subscription? I have only managed to find the status of the last subscription, using the following query:

  Select ReportSchedule.ScheduleID, Catalog.Name, Subscriptions.Description, Subscriptions.LastStatus, Subscriptions.LastRunTime

  From ReportSchedule join Subscriptions on ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID

  join Catalog on Subscriptions.Report_OID = Catalog.ItemID

  Is there a way to see the subscription status for, let's say, the past week?

• Carol Adams

  SSCrazy

  Points: 2320

  More actions

  March 4, 2010 at 11:33 am

  #1128672

  go to http://www.sqlservercentral.com/articles/ssrs/69257

  at the bottom of the article is a zip file you can download that has the reports...I use it these reports alot....