SQL Query to get Folder structure out of Report Manager
Posted on 2013-09-06
I'm using SQLServer 2008 R2 and I'm trying to create a report to help me managing the security for all my groups and users across all my folders and reports. I want to see users/groups for the parent folder and what security is allocated to each one, and then see the same for all the subfolders and finally the reports.
In the 'Catalog' table I have a path like ParentFolder/subfolder1/subfolder2/subfolder3/report1 or similar for each item.
Is there a field in any table that can help me to identify the level- sub level of the each folders?
Alternatively, does anyone know how to get an overview of the security allocated to each object (folder, subfolders, reports...) in Report Manager?