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

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

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