Skip to main content

Seeking for a list of users who have logged into Mosaic

In this article, we explain how to get a list of workers who accessed Mosaic on a specific date when the standard report times out.

Y
Written by Yusef Abulaynain
Updated over 5 months ago

Users and Workers logins are stored in the MO_SESSIONS table, if you have back-end access then you can tweak and run the following query. If not, you can raise a new support case to request this.

You should be able to output the results into .csv for filtering in Excel etc.
​
Example query, for all users who used the Mosaic logged in on 20th November 2023:​

select worker_id, logon_datetime, logoff_datetime from mo_sessions where logon_datetime >= '20231120' and logon_datetime < '20231121' order by logon_datetime asc
Did this answer your question?