Hi all
admin interface you have the info "last login" also shown in
the overview table. :)
SELECT CONCAT(first_name,last_name) as Agnet_Name ,u.login, Preferences_value as LastLogin FROM otrs.user_preferences,users u
where preferences_key like '%UserLastLoginTimestamp%'
and user_id = u.id
or
SELECT CONCAT(first_name,last_name) as Agnet_Name ,u.login, FROM_UNIXTIME(Preferences_value) as LastLogin FROM otrs.user_preferences,users u
where preferences_key like '%userlastlogin%'
and user_id = u.id
Thank you & Regards,
Kalyana chakravarthy M .P,
Sr software Engineer.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs