Users make 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
| Warning |
|---|
SQL skills are requiredA working knowledge of SQL Management Studio is required to complete this task |
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.
...
In this example session 66 is to be ended. Run the following
KILL
...
66
Related articles
| Filter by label | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|