Help custom stats

[dario098]

i need to make a query on mysql db to read the last login from customer users.

In which table can i find this field?

Thanks in advance

[Giulio Soleni]

Hi,
for presently logged in users you may look at the session table and check for 'UserSessionStart' entries... just elaborate the following query:
SELECT * FROM sessions WHERE data_key = 'UserSessionStart'

But this is valid for the presently logged on users or, more in general, for session not yet expired.

I think - but I am not sure - that to check the login of people that is no more connected you should parse the logs.

[dario098]

i mean this :



where can i find this field?

[reneeb]

Code: Select all

SELECT * FROM customer_preferences WHERE preferences_key = 'UserLastLogin';