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