TM1 Forum

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

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

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

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.

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

monkey97 wrote: ↑Wed Aug 23, 2023 6:24 am 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

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