Cognos security group database

[monkey97]

Hi all!

We have got some security groups in cognos which sync with TM1.
If we have to delete some people from groups, we have to solve it manually one by one.
Where can i find database of these groups? What is it stored in anyway and how can it be accessed?

It is important, because if we get more than 10 people for delete, it will be easier with sql script or anything.

Thanks in advance

[Wim Gielis]

Did you mean the function "RemoveClientFromGroup" in a Turbo Integrator process ?

https://www.ibm.com/docs/bg/cognos-tm1/ ... tfromgroup

[monkey97]

We use it on TM1, it can delete clients from }Clients on TM1, but we have to delete them from Cognos BI security group too.

[Wim Gielis]

I haven’t done that, if at all possible.

[HighKeys]

We use it on TM1, it can delete clients from }Clients on TM1, but we have to delete them from Cognos BI security group too.

Hi, do you use Cognos Groups or do you use LDAP Groups in Cognos?

If you use LDAP Groups you should automate there, otherwise IBM has a Example how to Add Everyone to SystemAdministrator in SQL, i'm sure you can use that as a base to create a SQL script which removes users from the group.

You can find the example script in <Cognos Analytics Install Dir>\configuration\schemas\content\ its called AddSysAdminMember.sql

Hope this helps you
BR

[vovanenok]

You can do it using the Cognos REST API:
https://developer.ibm.com/apis/catalog/ ... from_group

Send me a direct message if you consider 3rd party paid products with this functionality implemented