Last login time for admins not updating properly?

[tmeader]

This may be the normal behavior (and we're only just noticing it?) but it seems that the Last Login timestamp noted under https://xxxxxxxx/otrs/index.pl?Action=AdminUser doesn't appear to be updating in a timely manner with version 6.0.40?

Looking at the log entries, we can see the expected "User xxxx authenticated" messages being displayed, so at least that entry is being noted properly. There just seems to be a disconnect between the noted login in the logs, and the AdminUser interface properly noting the last login time.

Anyone else noticing the same?

Thanks.

[root]

This may be the normal behavior (and we're only just noticing it?) but it seems that the Last Login timestamp noted under https://xxxxxxxx/otrs/index.pl?Action=AdminUser doesn't appear to be updating in a timely manner with version 6.0.40?

Looking at the log entries, we can see the expected "User xxxx authenticated" messages being displayed, so at least that entry is being noted properly. There just seems to be a disconnect between the noted login in the logs, and the AdminUser interface properly noting the last login time.

Hi,

The changed time shown in AdminUser is related when the user is edited in this screen. The time your searching for is stored in another table, use the SQL box to access this data:

PostgreSQL

Code: Select all

SELECT u.login,u.first_name,u.last_name,TO_TIMESTAMP(CAST(up.preferences_value as BIGINT))::date FROM users u LEFT JOIN user_preferences up ON (u.id=up.user_id) WHERE up.preferences_key='UserLastLogin'

MariaDB/MySQL

Code: Select all

SELECT u.login,u.first_name,u.last_name,FROM_UNIXTIME(up.preferences_value) FROM users u LEFT JOIN user_preferences up ON (u.id=up.user_id) WHERE up.preferences_key='UserLastLogin';

- Roy