Cognos Analytics

 View Only
Expand all | Collapse all

Cognos license count not reduced even after removing users from groups and capabilities...

  • 1.  Cognos license count not reduced even after removing users from groups and capabilities...

    Posted Wed June 30, 2021 10:46 AM
    Edited by System Fri January 20, 2023 04:33 PM
    On Cognos connection, when I click on Manage->Licenses, it shows license counts.
    That count doesn't sync with our users in Cognos groups.
    I checked capabilities to see if any group other than what we assign users to exist and they all are okay.
    Anonymous and Everyone are disabled.
    However, license count doesn't go down.
    I checked cmobjprops33 and the users we removed from managed groups still exist there as using License 1 (Analytics Users).
    Where else to check?
    Is there a SQL to get roles assigned to these users in content db? I can query groups and roles but not capabilities and any other things that may make them look like licensed users.
    Thank you for suggestions.

    ------------------------------
    Suraj Neupane
    ------------------------------
    #CognosAnalyticswithWatson


  • 2.  RE: Cognos license count not reduced even after removing users from groups and capabilities...

    IBM Champion
    Posted Wed June 30, 2021 10:55 AM

    Hey Suraj,
    my latest knowledge is, that this is "works as designed" behaviour. The license count will only be updated if the user's profile will be deleted from the content store or if it gets updated during next login of the user. Until then, they will always appear in the list.

    If you want to delete the user's profile, go do Administration console-> Security -> Users, Groups and Roles -> [your authentication namespace] and search for the corresponding users. In the more menu you can delete the profile.

    Keep in mind that this will delete all personal settings and saved user-defined content in the "My folder" of the user.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------

    Original Message


  • 3.  RE: Cognos license count not reduced even after removing users from groups and capabilities...

    Posted Wed June 30, 2021 11:46 AM
    Hi Robert,
    Thank you for suggestion.
    There are hundreds of users since who knows when this is going on so if that works, we'll add it as a step while removing users.

    ------------------------------
    Suraj Neupane
    ------------------------------

    Original Message