Is there a way to 'kill' or terminate a user session?

Users may end a terminal server session or turn off their computer without logging out of Jiwa.  This can leave the user logged in and consuming a Jiwa licence.

Step-by-step guide

Run the following script to identify the session to be ended

^{SELECT sys.sysdatabases.name [database name], hostname, program_name, sysprocesses.spid
FROM sys.sysprocesses
JOIN sys.sysdatabases ON sys.sysdatabases.dbid = sys.sysprocesses.dbid
WHERE program_name like 'Jiwa Financials%'
ORDER BY [database name] desc}

From the resulting list, identify the relevant session to end.

Open

In this example session 66 is to be ended.  Run the following

^{KILL 66}

Related articles