view all subscriptions in Reporting Services

SELECT
       c.Name
       ,c.Description
       ,C.Path
       ,sub.SubscriptionID -- ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData=''
       ,sub.Description
       ,sub.LastStatus
       ,sub.LastRunTime
       ,sc.enddate
FROM dbo.Catalog AS c
   INNER JOIN dbo.ReportSchedule AS rs
       ON rs.ReportID =c.itemid
   INNER JOIN dbo.Schedule AS sc
       ON sc.ScheduleID= rs.ScheduleID
   INNER JOIN dbo.Subscriptions AS sub
       ON rs.SubscriptionID =sub.SubscriptionID