Re: [otrs] Agent last Login timestamp?
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
Re: [otrs] Agent last Login timestamp?
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
Re: [otrs] Agent last Login timestamp?
Or in OTRS 3.0, in admin interface you have the info "last login" also shown in the overview table. :) In case you want to access the data via the API, you can use GetUserData() and use the attribute "UserLastLogin", which is an unix time stamp (also available in OTRS 2.4). Greetings, -Martin On 02.07.2010, at 09:50, Marco Vannini wrote: > Yes it should be in the log > > MV > > On Fri, Jul 2, 2010 at 9:33 AM, Amit Sharma wrote: > Hi, > > Is there any way to find agent last login timestamp? > > regards, > amit > OTRS 2.4.7 - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Agent last Login timestamp?
Yes it should be in the log MV On Fri, Jul 2, 2010 at 9:33 AM, Amit Sharma wrote: > Hi, > > Is there any way to find agent last login timestamp? > > regards, > amit > OTRS 2.4.7 > > > - > 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 > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ > - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
[otrs] Agent last Login timestamp?
Hi, Is there any way to find agent last login timestamp? regards, amit OTRS 2.4.7 - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/