Get user last time connexion

Hi
I’ve taken a look at the API and seen nothing related to last user connexion date and time

Is there a way to get the last time a user connected, either via web or drive ?

The idea is to close unused accounts and reclaim some space.

Hi,

it’s possible to get the results directly from the database:

SELECT * FROM seahub-db.base_userlastlogin where last_login < “2017-05-01 00:00:00”;

But I agree, it would be nice to get this information via an API call instead.

Best regards

Thomas

1 Like

Thank you for this SQL request. It’s simple and does exactly what I was looking for !

Best regards,
Zaq.

@DerDanilo such kind of information is very wellcome, maybe in “Hints and Tricks Database”. It is worth to include it, isn’t it?

1 Like