List of Users and folders they have accesss to

server administration BI4.3
1

If I have access to CMS DB. Can I pull the list of users and the folders they have access to?

2

Supposedly, but I don’t know of anyone who has done so successfully. I think it is partially due to how Business Objects stores that data. It’s the relationships that are complex.

3

and thats why there is a space for many 3rd party tools… e.g the mr landlord’s employer :smiley:

1 Like
4

Using your query builder:

http://server:8080/AdminTools/querybuilder/logonform.jsp

You can run this to see what report what users are in a group, you’ll need another query to see what folders the groups provide access to:

SELECT TOP 100000 SI_NAME, SI_DESCRIPTION, SI_EMAIL_ADDRESS, SI_USERFULLNAME, SI_CREATION_TIME, SI_LASTLOGONTIME
FROM ci_systemobjects
WHERE descendants(“si_name=‘Usergroup-User’”, “si_name=’’”)
ORDER BY SI_CREATION_TIME

5

The query does not return any result.

6

oops, bobj-board.org took out the code in the angle brackets, you will need to include a group name like this:

SELECT TOP 100000 SI_NAME, SI_DESCRIPTION, SI_EMAIL_ADDRESS, SI_USERFULLNAME, SI_CREATION_TIME, SI_LASTLOGONTIME
FROM ci_systemobjects
WHERE descendants(“si_name=‘Usergroup-User’”, “si_name=‘PRM-Azteca’”)