TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
Use ReportServer
Go
SELECT
DS.Name as DataSourceName, CT.Name AS ItemName, CT.Path
FROM
dbo.Catalog CT INNER JOIN
dbo.DataSource DS ON CT.ItemID = DS.ItemID
Where Type=2
Order by DataSourceName,ItemName
