List of existing report Subscription RRS feed

  • Question

  • Hi,

    Was wondering if someone could share a query to get a list of all existing report subscription that exist in the report server, and also, to find out the recurrence type, and like what time the report subscription was run, and so forth. I got stuck when joining the dbo.Schedule table as not sure what RecurrenceType code (1-5) means. I need to create a report of this. Any help is very much appreciated. Thanks.

    This is what I got so far:

    select ReportPath = reverse(substring(reverse(c.Path),CHARINDEX('/',reverse(c.Path),1),LEN(c.Path))),

    ReportName = reverse(substring(reverse(c.Path),1,CHARINDEX('/',reverse(c.Path),1)-1)),

    Recipient = replace(s.LastStatus,'Mail sent to ',''),

    LastStatus = s.LastStatus,

    LastRun = s.LastRunTime

    from dbo.Subscriptions s

    inner join dbo.ReportSchedule rs on rs.SubscriptionID = s.SubscriptionID

    inner join dbo.Catalog c on c.ItemID = rs.ReportID

    Monday, February 6, 2012 7:19 PM