DX NetOps

Expand all | Collapse all

Last logon activity for user - CAPM

Jump to Best Answer
  • 1.  Last logon activity for user - CAPM

    Posted 01-21-2020 11:54 AM
    Hi All,

    in CAPM 3.7 there is lots of improvements done in user management ,is there any way to get the details of last logon time for user , I need to get the last login time and date for all users .How to get it .


  • 2.  RE: Last logon activity for user - CAPM

    Posted 01-21-2020 02:46 PM
    On CAPC machine call the mysql
    use netqosportal
    select * from audit_log\G


  • 3.  RE: Last logon activity for user - CAPM

    Posted 01-22-2020 04:24 AM
    Can you share the snap or example .whether we need to run in CAPC server?


  • 4.  RE: Last logon activity for user - CAPM

    Posted 01-22-2020 04:47 AM
    *************************** 2200. row ***************************
    ID: 2200
    Product: PC
    Category: Sign Out
    SubCategory: NULL
    TenantID: 8
    UserID: 1
    Message: Logged out. User: admin, remote address: xx.xxx.xx.xx
    OccurredOn: 1579633142
    *************************** 2201. row ***************************
    ID: 2201
    Product: SSO
    Category: Sign In
    SubCategory: Succeed
    TenantID: NULL
    UserID: NULL
    Message: 2020-01-21 13:59:06, Product Code: pc, Username: admin, Remember Me : false, SSO version: 7.0, Remote Host: xx.xxx.xx.xx
    OccurredOn: 1579633146
    *************************** 2202. row ***************************
    ID: 2202
    Product: PC
    Category: Sign Out
    SubCategory: SSO Token
    TenantID: NULL
    UserID: NULL
    Message: User admin is logged out because the SSO token is expired. Remote a ddress: xx.xxx.xx.xx
    OccurredOn: 1579634428
    2202 rows in set (0.00 sec)

    ERROR:


  • 5.  RE: Last logon activity for user - CAPM
    Best Answer

    Posted 01-22-2020 04:49 AM
    You can also check on the following log

    /opt/CA/PerformanceCenter/sso/logs

    [root@**.**.**.*** logs]# cat SingleSignOnAuditLog2020-01-21.log
    2020-01-21 00:40:50, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***, Error Message: Unable to authenticate user.
    2020-01-21 00:41:06, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***
    2020-01-21 00:41:14, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***, Error Message: |Unable to authenticate user.
    2020-01-21 00:42:06, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***
    2020-01-21 00:44:37, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***, Error Message: Unable to authenticate user.
    2020-01-21 00:44:52, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***
    2020-01-21 11:01:22, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***
    2020-01-21 11:01:43, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***
    2020-01-21 13:06:52, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***
    2020-01-21 13:59:06, Product Code: pc, Username: admin, Remember Me: false, SSO version: 7.0, Remote Host: **.**.**.***


  • 6.  RE: Last logon activity for user - CAPM

    Posted 01-22-2020 11:08 PM
    Thanks ,Can i get the idle users list for last 6 months


  • 7.  RE: Last logon activity for user - CAPM

    Posted 01-29-2020 08:58 AM
    Any help on this ?