how to pull data source information on data-driven subscriptions

Question

I would like to know more about the data-driven subscriptions on our ReportServer. I am specifically looking for what shared data sources are being used, but the connection string would also suffice.

I have poked around the Subscriptions and DataSource tables, but nothing seems to give me the information I need. Any ideas?

Answer 1

I kept poking around and... found it. For the future reference of others:

select 
  Catalog.Name
, Subscriptions.[Description]
from
  Subscriptions
  join DataSource
    on Subscriptions.SubscriptionID = DataSource.SubscriptionID
  join Catalog
    on DataSource.Link = Catalog.ItemID