Report of all users and what folders and reports they have access to.

[lbaker2]

I am trying to write up some SQL to create a report showing all users and the reports and folders they have access to but I am struggling with it.
Would anyone happen to have done this before or have a sample SQL that is doing this same thing?

Thanks, Lincoln

[Justin Derrick]

Hi Lincoln -- as you've already discovered, it's very complicated...

You need to match a user to the groups they belong to, and then the user groups to Folders, and then to specific Application Groups and Applications -- and there might even be query restrictions involved which further reduce the pool of data an individual user might have access to.

In the past, I've had to manually copy access privileges between servers, and it was a real challenge to get everything working properly.

I'll go through some old scripts / notes and post some SQL that might be helpful.