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.
Original Message:
Sent: Aug 15, 2022 05:39 PM
From: Garin Walsh
Subject: list of active users operator console
something like
SELECT count(distinct user_id) FROM OC_SESSION where logout is null
or
SELECT distinct user_id FROM OC_SESSION where logout is null
Original Message:
Sent: Aug 15, 2022 02:29 PM
From: Technology Operations
Subject: list of active users operator console
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
Steve