Tungsten TotalAgility ships with a standard form to find the list of currently logged-on users. The standard form can be accessed from the default workspace navigation Administration >> Logged On Users (screenshot below for reference). The forms allows an administrator to review the logged on users plus remove any redundant sessions (force logout user/s).

There are times when you would run out of Tungsten Automation, formerly Kofax Concurrent User Licenses, and cannot login to the standard workspace to clear someone’s session. That is where we need to use the power of SQL to find the active sessions and remove the redundant sessions.

NOTE: The procedure explained here should be used with extreme caution as if you are not careful you may end up removing an active user’s session. The SQL query based approach is not supported by Tungsten Automation, formerly Kofax Technical Support.

The query needs to be executed on TotalAgility database, and helps you find the SESSION_ID to be removed.

Once you have the SESSION_ID, you may execute the DELETE script to remove the redundant session.