How can I find out who is logged into Jiwa - version 7.01.00 and higher?

Question

Is there a way to find out which users are logged into Jiwa? 

Answer

Run the following script to identify users logged into which database.

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

In this example of running the query, Ken is logged into the database JiwaDemo-721SR2 and Admin and Ann are logged into Demo-721SR2

Open