What is the query to see locks on the flag.bin file for users in the USERS table?

Version 1

    Details

    What is the query to see locks on the flag.bin file for users in the USERS table?


    Resolution

    The first character in the soundeffct column of the users table holds the flag if a user is logged in or not.  This is helpful if GoldMine crashes and you get the "max users are currently logged in" error.

    Select * from users where left(soundeffct,1) = '1'