Description:
The Technical Reference Guide says that the "WEB_LAST_LOGIN" field on the USP_Preferences table as "Indicates the time of the last web login.". However, this field is set NULL.
How may we check the last login date time of each contact?
Solution:
The "WEB_LAST_LOGIN" field is not used in the current releases.
However, you can query the session_log table to get that information.
Below is an example using Microsoft SQL:
Select dateadd(ss,MAX(s.login_time)+32400,'1/1/1970') as Last_Login_Date_Time,
s.contact, c.last_name, c.first_name,
c.userid
FROM session_log s
INNER JOIN ca_contact c
ON
s.contact = c.contact_uuid
GROUP BY s.contact, c.last_name, c.first_name,
c.userid