How to check the last login date/time of each contact.

Document ID : KB000020033
Last Modified Date : 14/02/2018
Show Technical Document Details


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?


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,, c.last_name, c.first_name,
FROM session_log s
INNER JOIN ca_contact c
ON = c.contact_uuid
GROUP BY, c.last_name, c.first_name,