This Script will list all the data sources by their actual name, and all their dependent items:
SELECT C2.NAME AS Data_Source_Name ,C.NAME AS Dependent_Item_Name ,C.Path AS Dependent_Item_Path FROM ReportServer.dbo.DataSource AS DS INNER JOIN ReportServer.dbo.CATALOG AS C ON DS.ItemID = C.ItemID AND DS.Link IN ( SELECT ItemID FROM ReportServer.dbo.CATALOG WHERE Type = 5 ) --Type 5 identifies data sources FULL JOIN ReportServer.dbo.CATALOG C2 ON DS.Link = C2.ItemID WHERE C2.Type = 5 ORDER BY C2.NAME ASC ,C.NAME ASC;
No comments:
Post a Comment