Last login per user

[Sburb]

Hello,

It doesn't seem possible to get the last login time per user.
I would like to display it in the user list.
And it could be useful to issue some reminder if someone did not connect for a long period of time, but the information does not seem to be available.

[jurnet]

Hi, did you find a solution ?

[yuri]

Hi,

It's only possible to see Last Access on the detail view. On the right panel.

[jurnet]

I have made some things :
Create a new field in contact like lastlogintime then create a mysql trigger : with :

 
 DELIMITER $$  CREATE TRIGGER after_auth_insert AFTER INSERT ON auth_log_record FOR EACH ROW BEGIN     IF NEW.portal_id IS NOT NULL THEN         UPDATE contact SET lastlogintime = new.created_at WHERE contact.id IN (SELECT contact_id FROM user WHERE user.user_name = new.username);     END IF; END$$  DELIMITER ;