Housekeeping on an old SSRS, this particular server is 2008R2.
I have the query below which gets me the name, location, creation and modification overview for all the reports. I would also like to include the 'Connection String' at least, and some other details if possible from the data sources properties. But I can't find it in ReportServer. I have seen people use PowerShell to get it out of SSRS web service, I was hoping to find a T-SQL solution.
How can I display Data Source details with a SQL query?
--List all the reports on SSRS via "ReportServer" database USE [ReportServer] GO SELECT Name --, [ItemID] --Primary key , [Path] , [Description] --, [CreatedByID] --need link to get anything usable from here , Created.UserName as CreatedByUser , [CreationDate] --, [ModifiedByID] --need link to get anything usable from here , Modified.UserName as ModifiedByUser , [ModifiedDate] FROM [dbo].[Catalog] left join (select [UserID] , [UserName] from [dbo].[Users]) as Created on Catalog.CreatedByID = Created.UserID left join (select [UserID] , [UserName] from [dbo].[Users]) as Modified on Catalog.ModifiedByID = Modified.UserID WHERE [Type] = 2 -- value per foundation Source http://sqlsrv4living.blogspot.com/2014/01/ssrs-get-list-of-all-reports-using.html ORDER BY [Path], Name