I recently had the need to get a list of all the reports that are on our SQL Server Reporting Services (SSRS) site. I didn’t want to have to go and type them all out or spend forever reformatting the text after copying and pasting it from the list on the site. So, I took a quick look at the database.
Here’s how to do it
- Open Microsoft SQL Management Studio.
- Connect to the server where the database resides.
- Open a new query window, connected to the SSRS database.
- Type the following in the query window.
SubString([Path],1,Len([Path]) – (CharIndex(‘/’,Reverse([Path]))-1)) As [Path],
When [Hidden] = 1
End As [Hidden]
Where [Type] = 2
Order By SubString([Path],1,Len([Path]) – (CharIndex(‘/’,Reverse([Path]))-1)),
- Press F5 or click ! Execute.
This will give you a list of the report name, description, path and whether it’s hidden or not. I hope this is useful!