Cognos Analytics

When a user leave the company, we would like to delete the user from Cognos automatically. 

At the moment, we remove the user from all Cognos groups but the cognos profile has to remove manually.

Is there a way to do that by script?

SDK or via SQL statement to the content store?

------------------------------
Gero Wanning
Senior Consultant Manager
Sievers Group
Osnabrück
------------------------------

Hi Gero,

In the public CA REST API there is a REST endpoint for /users/{id} which supports the DELETE action.

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=api-rest-reference

(It's in the "accounts" section of the swagger documentation)

e.g. DELETE  http://{ca-hostname}:9300/api/v1/users/{id}

You'll need to authenticate, before sending this request (the REST documentation above covers how to do that as well.)

When a user leave the company, we would like to delete the user from Cognos automatically. 

At the moment, we remove the user from all Cognos groups but the cognos profile has to remove manually.

Is there a way to do that by script?

SDK or via SQL statement to the content store?

------------------------------
Gero Wanning
Senior Consultant Manager
Sievers Group
Osnabrück
------------------------------

When a user leave the company, we would like to delete the user from Cognos automatically. 

At the moment, we remove the user from all Cognos groups but the cognos profile has to remove manually.

Is there a way to do that by script?

SDK or via SQL statement to the content store?

------------------------------
Gero Wanning
Senior Consultant Manager
Sievers Group
Osnabrück
------------------------------

Hi Gero,

based on the statement "user leave the company" I assume the user is removed in the authentication system. If so, the default functionality of Cognos "Consistency Check" will be able to remove this profile(s) (where no reference to the authentication system exists anymore).

See Administration console >> Configuration >> Content Administration >> Maintenance-Icon >> Consistency Check

Create on and run "Find only" to first see what would be deleted and then run again with "Find and fix" to delete the object(s).

You can also schedule the "Find and fix" per day/week to remove such user profiles automatically.

When a user leave the company, we would like to delete the user from Cognos automatically. 

At the moment, we remove the user from all Cognos groups but the cognos profile has to remove manually.

Is there a way to do that by script?

SDK or via SQL statement to the content store?

------------------------------
Gero Wanning
Senior Consultant Manager
Sievers Group
Osnabrück
------------------------------

Hi Gero,

based on the statement "user leave the company" I assume the user is removed in the authentication system. If so, the default functionality of Cognos "Consistency Check" will be able to remove this profile(s) (where no reference to the authentication system exists anymore).

See Administration console >> Configuration >> Content Administration >> Maintenance-Icon >> Consistency Check

Create on and run "Find only" to first see what would be deleted and then run again with "Find and fix" to delete the object(s).

You can also schedule the "Find and fix" per day/week to remove such user profiles automatically.

When a user leave the company, we would like to delete the user from Cognos automatically. 

At the moment, we remove the user from all Cognos groups but the cognos profile has to remove manually.

Is there a way to do that by script?

SDK or via SQL statement to the content store?

------------------------------
Gero Wanning
Senior Consultant Manager
Sievers Group
Osnabrück
------------------------------

Hi Michael,

I am having a similar cleanup challenge as Gero having identified a large number of user using the "Find only" option.

Is there a way to delete the users manually from the content store as I do not want to remove everyone the list right away?

Hi Gero,

based on the statement "user leave the company" I assume the user is removed in the authentication system. If so, the default functionality of Cognos "Consistency Check" will be able to remove this profile(s) (where no reference to the authentication system exists anymore).

See Administration console >> Configuration >> Content Administration >> Maintenance-Icon >> Consistency Check

Create on and run "Find only" to first see what would be deleted and then run again with "Find and fix" to delete the object(s).

You can also schedule the "Find and fix" per day/week to remove such user profiles automatically.

When a user leave the company, we would like to delete the user from Cognos automatically. 

At the moment, we remove the user from all Cognos groups but the cognos profile has to remove manually.

Is there a way to do that by script?

SDK or via SQL statement to the content store?

------------------------------
Gero Wanning
Senior Consultant Manager
Sievers Group
Osnabrück
------------------------------