Cacher is the code snippet organizer for pro developers

SELECT
SUB.SubscriptionID
,USR.UserName AS SubscriptionOwner
,CAT.[Path] AS ReportPath
,SUB.ModifiedDate
,SUB.[Description]
,SUB.EventType
,SUB.DeliveryExtension
,SUB.LastStatus
,SUB.LastRunTime
,SCH.NextRunTime
,SCH.Name AS ScheduleName
,CAT.[Description] AS ReportDescription
FROM dbo.Subscriptions AS SUB
left outer JOIN dbo.Users AS USR
ON SUB.OwnerID = USR.UserID
left outer JOIN dbo.[Catalog] AS CAT
ON SUB.Report_OID = CAT.ItemID
left outer join dbo.ReportSchedule AS RS
ON SUB.Report_OID = RS.ReportID
AND SUB.SubscriptionID = RS.SubscriptionID
left outer join dbo.Schedule AS SCH
ON RS.ScheduleID = SCH.ScheduleID
--where (@SubscriptionOwner = '' or USR.UserName = @SubscriptionOwner)
--and CAT.[Path] like '%%'
ORDER BY LastRunTime desc

--exec [SSRSReportServer].dbo.AddEvent @EventType='TimedSubscription', @EventData='47e16083-c0f6-4ad8-b37f-0910d62b185b'