Skip to end of metadata
Go to start of metadata

Users make end a terminal server session without logging out of Jiwa.  This can leave the user logged in and consuming a Jiwa licence.

Step-by-step guide

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

Run the following script to identify the session to be ended

SELECT [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.

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