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.
Last login time for admins not updating properly?
Moderator: crythias
-
- Administrator
- Posts: 3985
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Last login time for admins not updating properly?
Hi,tmeader wrote: ↑01 Apr 2022, 17:43 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.
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'
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';
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?