The Number of Users Decreased after Upgrade to OnApp 6.0+

Question

Why has the number of users displayed in the sidebar on my Control Panel decreased after the upgrade to OnApp 6.0 or further versions?

Environment

OnApp 6.0 or above

Answer

Starting with 6.0, OnApp provides the number of active users in the sidebar on your Control Panel. Users who are suspended or deleted, as well as the system users, are not taken into account. If you activate a suspended user, the number in the sidebar increases. 

Additional Information

You can run the following command on your database to check the number of active users displayed in the sidebar:

select count(*) from users where status ='active';

You can run the following command to check if the total number of users on the database has not changed after the upgrade to 6.0 or above:

select count(*) from users;