How many users are registered on my Matomo?
To find out the total number of registered users on your Matomo, first log in to your Matomo as a Superuser. If your user has the Matomo Admin role then you might not see all the users.
In Matomo 3 and newer
When you are logged in, click on Matomo settings (Administration) in the top right corner to load the admin area.
- In Matomo Cloud, Billing owners can view registered users in Account > Billing > Plan Quota.
- In Matomo On-Premise, the number of users is shown in the widget System Summary in the top left of the administration home page.
In Matomo 2
When you are logged in, click on Matomo settings (Administration) in the top right corner to load the admin area.
Click on Users in the left menu of the administration area, then scroll down to the Users Management section. It will show you the total number of users registered on your Matomo in the first paragraph of that section.
How can I find the last login time for users on my Matomo?
You can view the Last seen time of a user’s login under System > Users > Manage Users.
From Matomo 5.4.0, Superusers can receive a monthly report listing accounts that have not logged in for more than six months. This helps to review and remove accounts that may no longer be needed.
- To enable this, go to Matomo settings (Administration)
> System > General Settings > UsersManager.
- Activate the option, Send monthly security email with list of inactive users.
- Click Save.
Note: For Matomo On-Premise installations, you can check when users last logged into your Matomo by using the following SQL query.
It retrieves the usernames and their last login timestamps. If a user has never logged in, the last_seen
field will return an empty value.
SELECT
matomo_user.login,
CASE
WHEN matomo_option.option_value IS NULL THEN ''
ELSE FROM_UNIXTIME(matomo_option.option_value)
END AS last_seen
FROM
matomo_user
LEFT JOIN
matomo_option
ON
matomo_option.option_name = CONCAT('UsersManager.lastSeen.', matomo_user.login);