Cognos Analytics

 View Only
  • 1.  Delete Cognos user profile by script

    Posted Wed November 29, 2023 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

    IBM Champion
    Posted Thu November 30, 2023 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 Thu November 30, 2023 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 Thu November 30, 2023 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 Thu November 30, 2023 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 Mon December 04, 2023 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 Tue December 05, 2023 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
    ------------------------------