Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Delete Cognos user profile by script

    Posted 11/29/23 02:18 PM

    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
    ------------------------------



  • 2.  RE: Delete Cognos user profile by script

    Posted 11/30/23 01:36 AM

    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.)



    ------------------------------
    Jim Boland

    LinkedIn: https://www.linkedin.com/in/jimboland
    Website: https://coreinsightz.com
    Email: jimboland@coreinsightz.com
    ------------------------------



  • 3.  RE: Delete Cognos user profile by script

    Posted 11/30/23 04:26 AM

    Thank You Jim! 

    I will try it.



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



  • 4.  RE: Delete Cognos user profile by script

    Posted 11/30/23 02:30 AM

    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.



    ------------------------------
    Michael Haaß
    IBM
    Germany
    ------------------------------



  • 5.  RE: Delete Cognos user profile by script

    Posted 11/30/23 04:25 AM

    Hallo Michael,

    thank you for your answer. 

    When the user leave the company the user will not be deleted in the AD, only deactivated.. So the Consistency Check did not work here. 



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



  • 6.  RE: Delete Cognos user profile by script

    Posted 12/04/23 05:18 AM

    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?



    ------------------------------
    Dagur Egonsson
    ------------------------------



  • 7.  RE: Delete Cognos user profile by script

    Posted 12/05/23 04:03 AM

    Hi Dagur

    you can delete a single user profile manually with the ("old") Administration console. In tab "Security" click on the external namespace and then either click down to the user or use the search functionality to find the user. 

    Users which logged on to Cognos are shown in blue color (with a link to "my folders"), have a date (last access) and at the right side there is a "More..." link where you find the option "Delete this user's profile".

    (This "More..." option does not exists in the "new" Manage > People > Accounts section)



    ------------------------------
    Michael Haaß
    IBM
    Germany
    ------------------------------