How to list all the databases/Schema/tablenames used in SSRS Reprts' datasets.

[BeeTrees]

Hi All,


I was able to query all the reports and associated datasource and datasets and or command text even the fields. But is there any way i can get list of databases/Schema/tablenames used in SSRS Reprts' datasets using script. OR is there any third party tool to do this

Thanks

 

[gmmastros]

Fave you tried something like this?

select * from sys.databases
Select * From sys.tables
Select * From sys.Schemas

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[simian336]

Did you mean that you need a list of the tables that are actually used as part of the datasets that make up the current reports that you have created?

Simi