1

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?

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
1
  • 1
    Thanks for adding your own solution! Don't forget to accept it if it solved your case. – Jeroen May 2 '12 at 21:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.