Print Page - how to find which user belongs to which group/role

Title: how to find which user belongs to which group/role
Post by: Raghuvir on 30 Jun 2014 07:16:28 AM

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

Title: Re: how to find which user belongs to which group/role
Post by: sunosoft on 01 Jul 2014 04:21:14 AM

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.

Title: Re: how to find which user belongs to which group/role
Post by: Yunus on 03 Jul 2014 08:44:56 AM

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.

Title: Re: how to find which user belongs to which group/role
Post by: Raghuvir on 08 Jul 2014 10:24:07 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Raghuvir on 30 Jun 2014 07:16:28 AM