DX NetOps

Expand all | Collapse all

Last logon activity for user - CAPM

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

    Posted 28 days ago
    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 27 days ago
    On CAPC machine call the mysql
    use netqosportal
    select * from audit_log\G


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

    Posted 27 days ago
    Can you share the snap or example .whether we need to run in CAPC server?


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

    Posted 27 days ago
    *************************** 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 27 days ago
    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 26 days ago
    Thanks ,Can i get the idle users list for last 6 months


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

    Posted 20 days ago
    Any help on this ?