Get List of Report Folders

DROP PROC usp_GetSSRSFolderList

GO

CREATE PROC usp_GetSSRSFolderList

AS

/****************************************************

Purpose: To retreive a list of report server folders.

Uses the Catalog table in the report server

database (assumed to be called by its default

name of 'ReportServer')

Author: ChillyDBA

History: 25 Jul 2012

*****************************************************/

SELECT

cat.TYPE,

cat.Name,

cat.Path

FROM ReportServer..Catalog AS cat (NOLOCK)

WHERE TYPE = 1 --folders only

AND ISNULL(cat.Name, '') <> ''

ORDER BY path