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

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, Please raise a 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?