Hi Pete - Try this. They sure don't make it intuitive... 🙂
SELECT c2.Name AS ReportName
,s.Description AS SubscriptionbName
,c.Name AS SubscriptionDataSource
,s.DataSettings AS SubscriptionDatasetQuery
,s.Parameters AS SubscriptionDatasetParameters
FROM dbo.Subscriptions AS S
INNER JOIN dbo.DataSource AS DS
ON S.SubscriptionID = DS.SubscriptionID
INNER JOIN dbo.Catalog AS C
ON ds.link = c.ItemID
INNER JOIN dbo.Catalog AS C2
ON s.Report_OID = c2.ItemID
"The Bible tells us to love our neighbors, and also to love our enemies; probably because they are generally the same people." G. K. Chesterton