how to find which user belongs to which group/role

[Raghuvir]

hi all,

i have to find out the list of users present in cognos and also in which group/role they belong. is there any way we can find this out from the content store tables ?

Regards

[sunosoft]

I was having below link with me where Suraj gave really very good information about content store tables.

http://www.cognoise.com/index.php/topic,17411.msg50409.html#msg50409

Check if you can play with content store DB with the hints provided by Suraj.

[Yunus]

Have you considered reporting against your LDAP database?  That would provide a more complete list, something that we encountered was that users did not appear in the Cognos table until they logged in or at least attempted to login, the LDAP itself (Active Directory in my case) contains the complete set of data.

[Raghuvir]

hi,

i tried quering the CMOBJPROPS1 table in the content manager to find out the same but i am only able to find these groups

::Everyone
::System Administrators
::Anonymous
::All Authenticated Users

rest all are codes which i m not understanding. has anyone done this before ?

Regards