This should get you to a pretty good starting point

SELECT

U.UserName AS SubscriptionOwner,

C.Path AS ReportPath,

CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,

S.EventType AS SubscriptionType,

CONVERT(XML,S.Parameters) AS ReportParameters,

S.DeliveryExtension AS DeliveryMethod,

Sc.Name AS ScheduleName,

Rs.ScheduleID

FROM

Subscriptions S

INNER JOIN

Users U

ON

S.OwnerID = U.UserID

INNER JOIN

Catalog C

ON

S.Report_OID = C.ItemID

INNER JOIN

ReportSchedule RS

ON

S.SubscriptionID = RS.SubscriptionID

INNER JOIN

Schedule Sc

ON

RS.ScheduleID = Sc.ScheduleID

ORDER BY

1,2