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

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
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: