We help IT Professionals succeed at work.

Create list of all reports a user has access to in SSRS

cbroch
cbroch asked
on
Medium Priority
791 Views
Last Modified: 2012-06-22
Can a sql query be created that provides a list of all the reports a user has access to in SSRS? I'm looking for the users that are specified in the "Security" tab of each report in the SSRS database. I'm not concerned with users within a group.  We are migrating from SQL 2005 to SQL 2008 R2 and would like to notify the users of each report to take a look at their reports to ensure they are still functioning properly.

Thanks in advance for any help you can provide.

Curt
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Nicobo,

That is a thing of beauty! Thank you very much.

Curt
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.