Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Cognos Audit report for users and groups

    Posted Wed May 12, 2021 01:32 PM
    Hi, 
    I have reports that show users logon history and other things.
    What I'm looking for is list of users/groups that were added by admin for access whether or not they ever logged on to the system.
    The reports I see only give output if user logon at least once.
    Is there a way to generate a report of users by date they were added?
    Thanks

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

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Audit report for users and groups

    Posted Thu May 13, 2021 07:01 AM
    Hi Suraj
    Have you looked at the [CMOBJPROPS33] table? I don't know of a way to see when they were added out of the box.

    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 3.  RE: Cognos Audit report for users and groups

    Posted Wed May 19, 2021 03:33 PM
    Hi Trevor,
    That table doesn't have date of users added to groups/roles.
    It only has LASTLOGIN field.
    I'm looking for date when a new user is added regardless of whether that user ever logged on or not.

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

    Original Message


  • 4.  RE: Cognos Audit report for users and groups

    Posted Thu May 20, 2021 03:42 AM

    Hi Suraj,
    Try this query to get the creation date of a user:

    SELECT
     c33.cmid user_id
    ,c33.NAME AS ldap_id
    ,c33.USERID loginuser
    ,c33.LASTLOGIN lastlogin
    ,ud.created
    ,c33.LICENSE license
    ,c1.surname last_name
    ,c1.givenname first_name
    ,c1.email email
    ,c1.objid
    FROM cmobjprops1 c1
    LEFT JOIN cmobjprops33 c33
    ON c33.cmid = c1.cmid
    LEFT JOIN
    ( SELECT CMID, CREATED
    FROM CMOBJECTS
    WHERE CLASSID = 5 -- account
    ) UD
    ON UD.cmid = c1.cmid
    WHERE c33.cmid is not null
    ;



    ------------------------------
    Thomas van der Meer
    ------------------------------

    Original Message


  • 5.  RE: Cognos Audit report for users and groups

    Posted Thu May 20, 2021 02:09 PM

    Thanks Thomas.
    I need to work on little bit to get the final result but that gives me starting point.



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

    Original Message


  • 6.  RE: Cognos Audit report for users and groups

    Posted Thu May 20, 2021 07:09 AM

    Suraj Neupane – to answer this question and get the user creation date, you may have to audit your Active Directory server, assuming you are using an Active Directory server for access/security.

     

    Peter Chan

    613-295--0428

     




    Original Message


  • 7.  RE: Cognos Audit report for users and groups

    Posted Fri June 11, 2021 01:06 PM
    Short notice. You can see the information at what time a user was added only if the user is directly added to a cognos role. Because in this case the user profile will be created immediately. Adding an external group (with a bunch of users) to a cognos role then no user profiles will be created. Only if some of these users really logon to cognos the user profile is created.

    ------------------------------
    Michael Haaß
    ------------------------------

    Original Message


Related Content