Retrieve matomo user last connexion

(Candaj) #1


I would like to know the users that have not been connected to matomo since a certain amount of time. I know we can have it in the user management view on the column “last seen” . But I’ve 905 users on my matomo instance today and I would like to do some automatic cleaning based on the last seen value and not manually delete it through the UI.
Is there a way to retrieve this data through API or database or something?
I’m in 3.5.1 version