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 Super User. 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 the « Administration » icon in the top right corner to load the admin area.

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 the « Administration » icon 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?

Note: For Matomo on-premise installations.

To check when users last logged into your Matomo, you can use 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);