Is there an SQL Query to see all users logged into GoldMine?
1. Tools > SQL Query
2. Paste in the following query:
Select * from users where left(soundeffct,1) = '1'
3. Click the Query button
The first character in the Soundeffct column of the users table denotes if a user is logged in to GoldMine or not.
Blank - Never logged in
0 - Logged out
1 - Logged in