How to check permissions in Reporting Services programmatically

get-all-permissions-SQL-reporting-servicesOne day we found that we need to check users and groups permissions on SQL Reporting Services to understand who has access to what. So the next question is how to get all permissions in SQL Reporting Services programmatically and possibly export them to Excel for future analysis. After some time searching I ended up with the following SQL query:

This query returned all SQL Reporting Services users and their respective permissions.

If you need permissions list for particular user you can use the following query:

Now simple combinations like Ctrl+A, Ctrl+C and Ctrl+V in the Excel spreadsheet and you have all the information as convenient table!

Good luck!


Want me to do this for you? Drop me a line: itgalaxyzzz {at} gmail [point] com