Users currently logged in time

[Nathan_Pizer]

Does anyone know what database table this login time comes from?

In the thick client under admin -> user management -> view current users

Many Thanks,

Nathan

[Eric_Maerz]

Hi Nathan

The table is called 'hsi.loggeduser'.

You can always start the thick client with the verbose logging parameter '-V SQL' and have a look at the SQL queries yourself. The log is written to the user's temp path.

Best Regards

Eric

[Nathan_Pizer]

Hi @Eric Maerz,

Thanks for you response, what is the column name for login time? None of the columns have the data type as DateTime.

I'll give the verbose logging a try.

Thanks.

[Nathan_Pizer]

Hi @Eric Maerz 

I attempted the -V SQL parameter and didn't return the same results as the 'users currently logged in' window. Also no fields/columns from the logged user table appear to display the login date and time.

Regards,

Nathan

[Eric_Maerz]

Hi Nathan

It seems to be calculated via the 'checkin' column. You can order your SQL result by checkin and order by login time in the Thick Client GUI and then compare the results.

The checkin column seems to be 'minutes since date X' - very similar to an 'epoch' timestamp. On my test environment, X seems to be 28 years, 5 months in the past.

Regards,

Eric