In UIM 9.20, we used a jdbc_response probe that performed query "select count(1) as UMP_SESSION from umpSession where logout is null" to create a Value QoS. This way we could create a report on the number of active UMP usersessions over time. We are interested in that because we like to know at what times our users are most active, and for performance reasons, we do not want to exceed 20 usersessions per UMP/OC server.
I noticed that the umpSession table is not used anymore by Operator Console in UIM 20.3. So how can we monitor active user sessions over time?
Does OC report active user sessions in another table? And if not, how can we reproduce this functionality?
In UIM 20.4, for the Operator Console, the OC_SESSION table now contains the user session data.
SELECT * FROM OC_SESSION
Tested and confirmed that the user session data is provided in UIM 20.4 (Operator Console).
old table name-> umpSession (pre-20.3)
UIM 20.3.x - Auditing Operator Console logins
new table name-> oc_session (as of UIM 20.4 or higher)