DX Unified Infrastructure Management

 View Only
  • 1.  list of active users operator console

    Posted Aug 15, 2022 02:30 PM
    Edited by Technology Operations Aug 15, 2022 02:31 PM
    Is there a way to get a list of active users logged into the operator console?

    I didn't find anything in the application.wadl or the database and the manual for the wasp doesn't appear to mention that topic.

    we are using UIM 20.4.3


  • 2.  RE: list of active users operator console

    Posted Aug 15, 2022 02:36 PM
    How to detect, check or audit OC user sessions - login or logout activity in UIM Operator Console 20.4
    Article Id: 227047

  • 3.  RE: list of active users operator console

    Posted Aug 16, 2022 05:29 PM
    Perfect.  Thanks David.

    for starters this is simple and seems to work nicely:
    select * from oc_session where logout is null

  • 4.  RE: list of active users operator console

    Posted Aug 15, 2022 05:40 PM
    something like

    SELECT count(distinct user_id) FROM OC_SESSION where logout is null


    SELECT distinct user_id FROM OC_SESSION where logout is null

  • 5.  RE: list of active users operator console
    Best Answer

    Posted Aug 16, 2022 08:47 AM
    I'm not sure how reliable this table is.

    I've been watching it periodically and it appears that it only reliably records successful login events and clicking the logout option in OC.

    If your session times out, the table isn't reliably updated though this appears to happen most of the time.

    If OC is restarted then login sessions live at the time are still reflected as logged in after a restart.

    For instance, at the moment, I have 18 records in the table with a null logout time. 13 of them are 4+ days old based on the login time. Well beyond the timeout for OC and while possible, I can't imagine those users have spent the last half week (would include a saturday and sunday which would show some dedication....) keeping the activity timer in OC refreshed.

    Only 2 of the remaining 5 sessions listed are active. 

    It appears that really the only thing this table is good for is auditing when a user has logged in. Not if they are currently logged in or how many are logged in. The inverse appears to be reliable too in that you could reliably determine that a user isn't logged in currently. 

    Part of this is understandable in that there's no persistent connection with a web app so it's difficult to determine if a user is still there if they just close the browser and walk away. On the other hand there should be something that is making sure the list in the table reflects the active sessions list in the web server.

  • 6.  RE: list of active users operator console

    Posted Aug 16, 2022 12:01 PM

    Thanks for doing a little research on this topic. I can corroborate your findings.

    I've opened an "idea" topic for development for this issue.




    Any and all emails sent to us may be monitored and/or stored by us to ensure compliance with relevant legislation, rules and policies. If we collect and use your personal data you provide us or which we otherwise collect in the course of our business we will use it in accordance with our privacy policy.

    This email, its contents, and any attachments transmitted with it are intended only for the addressee(s) and may be confidential and legally privileged. If you are not an addressee or authorized to act on their behalf, do not read, print, re-transmit, or store this email, any information contained in it, or any attachments. We do not waive any confidentiality by misdelivery. If you have received this email in error, please notify the sender immediately and then permanently delete this email from your system.

    Any liability for viruses is excluded to the fullest extent permitted by law.