How to find out how many users are working in Process Portal at the given time (for 8.5 and later version)?

If you use IBM BPM version 8.5 and later, you can find out the number of users connected to Process Portal using the table BPM_USR_RUNTIME_PROPS.


The table shows only users connected to Process Portal, except ProcessAdmin, ProcessCenter and so on.

The list of users (Oracle query):
SELECT U.USER_NAME FROM BPMDB.BPM_USR_RUNTIME_PROPS U WHERE U.ONLINE_STATUS = 'T';

The number of users:
SELECT count(U.ONLINE_STATUS) as USNUM FROM BPMDB.BPM_USR_RUNTIME_PROPS U GROUP BY U.ONLINE_STATUS HAVING U.ONLINE_STATUS = 'T';

If you use 8.5.7 - there is a bug and the solution does not work. Install CF 2016.12