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.