SQL Query to see all users logged into GoldMine

Version 1

    Details

    Is there an SQL Query to see all users logged into GoldMine?


    Resolution

    Within 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