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

View Subscription

SELECT
c.Name AS ReportName
, c.Type
, c.Description AS ReportDescription
, u.UserName AS ReportCreatedBy
, s.Description AS SubscriptionDescription
, s.DeliveryExtension AS SubscriptionDelivery
, su.UserName AS SubscriptionOwner
, s.LastStatus
, s.LastRunTime
, s.Parameters
,sch.StartDate AS ScheduleStarted
,sch.LastRunTime AS LastSubRun
, sch.NextRunTime
, d.Name AS DataSource
, c.Path
FROM
Catalog c
LEFT OUTER JOIN  Subscriptions s ON c.ItemID = s.Report_OID
INNER JOIN  DataSource d ON c.ItemID = d.ItemID
LEFT OUTER JOIN  Users u ON u.UserID = c.CreatedByID
LEFT OUTER JOIN ReportSchedule rs ON c.ItemID = rs.ReportID
LEFT OUTER JOIN  Schedule sch ON rs.ScheduleID = sch.ScheduleID
LEFT OUTER JOIN Users su on s.ownerID = su.UserID
WHERE
c.Type = 2
and s.SubscriptionID is not null
ORDER BY c.Name