Force a log-off for all the users

Overview

Users are staying logged in overnight to the next day and it is causing accounting/reconciliation issues. How to force a log-off for all the users?

Solution

The steps below detail how to force user logoff in Everest:

1. Open SQL Server Management Studio
2. Connect using either windows authentication or SA authentication
3. Click on New query
4. Run the following to force all the users to log-off:

   USE everest_system;
   DELETE FROM everest_spm; 
   

   Note

   Forcing users to log-off may leave semaphore locks open. Semaphore locks are used to lock documents, journals, batch updates (reports), etc., so that two users cannot access the same profile/dialog box/window for concurrent modification. Open semaphore locks should be removed to prevent any unwanted behavior.

5. Run the following query to clear any open semaphore locks:
   

   USE EVEREST_{COMPANYCODE};
   DELETE FROM SEMAPHOR;
   

   Replace {COMPANYCODE} with your company code.

Running the queries above would break the connection to the client application. This would prompt the users to log back in.