Last Login column

Moderator: crythias

Locked
ptay
Znuny newbie
Posts: 85
Joined: 13 Jul 2010, 18:55
Znuny Version: 5.0.10

Last Login column

Post by ptay »

In the Admin > Customer Management screen there is a column listed for Last Login. Can someone point me to the DB table and column name that stores the Last Login date and timestamp?

Thanks.
Test:: OTRS 5.0.10 w/MariaDB 5.5.47 backend on RHEL7
Prod:: OTRS 5.0.10 w/MariaDB 5.5.47 backend on RHEL7
Top
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:
Contact crythias

Re: Last Login column

Post by crythias »

Code: Select all

select user_id, from_unixtime(preferences_value) as LastLogin from customer_preferences where preferences_key="UserLastLogin"
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Top
ptay
Znuny newbie
Posts: 85
Joined: 13 Jul 2010, 18:55
Znuny Version: 5.0.10

Re: Last Login column

Post by ptay »

That worked. thanks! Silly me, I was looking for a date and time column.
Test:: OTRS 5.0.10 w/MariaDB 5.5.47 backend on RHEL7
Prod:: OTRS 5.0.10 w/MariaDB 5.5.47 backend on RHEL7
Top
Locked

Return to “General”