What is your question? On 17 July 2013 11:24, KalyanaChakravarthy MP < KalyanachaKravarthy.MP@cybertech.com> wrote:
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