List all data sources

• Alexp012

  Old Hand

  Points: 369

  More actions

  December 13, 2022 at 9:15 am

  #4124765

  Hi

  is there a way to list all the data sources in SSRS 2016, and if possible which reports use them?

  Cheers

  Alex

• Chrissy321

  SSCoach

  Points: 15776

  More actions

  December 13, 2022 at 6:31 pm

  #4125131

  This should get you started.

  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) 
  FULL OUTER JOIN ReportServer.dbo.Catalog C2
  ON DS.Link = C2.ItemID
  WHERE
  C2.Type = 5
  ORDER BY
  C2.Name ASC,
  C.Name ASC;