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);