Archive

Posts Tagged ‘query’

T-SQL : Get all folder names from SSRS Reports Manager/Server

We all know, we can query the report server database and get very useful information, such as reports details, directory and schedules etc. This particular thread belongs to one such category, this query will provide you all available folders from a report server


select
ltrim(rtrim(Name))
from [dbo].[Catalog]
where type =1
and ParentID is not null

I will soon post other queries that will provide much more useful properties/information from report server.

Happy Querying 😉

Advertisements
%d bloggers like this: