Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

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
share|improve this answer
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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