Although there is not a tool in Biotics 5 which enables you to see this directly, below is a workaround for determining this information:
The session_log table holds this information, more or less. The application adds an entry when a user logs in, and updates it when they log out or when their session expires on the server due to half an hour of inactivity. There are a few edge cases in which logouts might not be detected:
- If a user closes their browser without logging out, their session is still counted as active for half an hour or so.
- If the application is restarted while somebody is logged in, a logout is never recorded for them. Queries will need to account for old entries, perhaps by just looking at the last week's worth of data.
Here's a query that can be used.
select * from session_log where session_ended is null and session_started >= (current_date - 7) order by session_started