Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS and Data Sources Expand / Collapse
Author
Message
Posted Monday, September 14, 2009 9:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:16 PM
Points: 75, Visits: 232
Does anyone out there know how to query the reports server database and find all reports by name and what data source they have attached to them.
Any help would be greatly appreciated. I have 315 reports I have to set data sources on and it's taking a huge amount of time to update the data sources on a new server (have to do this twice).

Thanks
Post #787561
Posted Monday, September 14, 2009 12:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:33 PM
Points: 1,143, Visits: 994
this should at least get you started

select * from catalog c inner join datasource d on
c.itemid = d.itemid
Post #787666
Posted Monday, September 14, 2009 12:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:16 PM
Points: 75, Visits: 232
For the most part that works, but I can't determine the shared datasource name on each report. Any thoughts
Post #787679
Posted Monday, September 14, 2009 1:20 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:33 PM
Points: 1,143, Visits: 994
select c.name as reportname, d.name as datasourcename from catalog c inner join datasource d on
c.itemid = d.itemid


you will have multiple rows per report if you use more than one datasource in any reports.
Post #787712
Posted Wednesday, July 14, 2010 7:25 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 19, 2014 4:36 AM
Points: 10, Visits: 382
There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change a single report / model or allow bulk changes for many reports and models.

There is also a health check feature, to detect and correct reports and models that have missing data sources. Multiple data sources for reports and models are also supported.

http://www.lecomputing.com/ssrsdatasourcemanager.html


Other uses can be- changing a selection of reports to another data source, eg moving from UAT/Development to production, or server loading issues.
Post #952809
Posted Tuesday, July 27, 2010 12:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 16, 2011 11:21 AM
Points: 169, Visits: 559
Adam Angelini (9/14/2009)
select c.name as reportname, d.name as datasourcename from catalog c inner join datasource d on
c.itemid = d.itemid


you will have multiple rows per report if you use more than one datasource in any reports.


Thanks Adam! This is exactly what I needed!



Post #959628
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse