License reporting incorrect number of users
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Confluence is displaying an incorrect number of active users.
Diagnosis
When running the queries below, you will see that it shows a different number of users than displayed in Confluence (probably a lower number):
1
SELECT * FROM cwd_user WHERE active = 'T';Resolution
Go to
> General Configuration> Users
Find the users that are supposed to be disabled (and that should not be counting towards the license) and remove them from all groups with CAN-USE permission.
After that, your license should display the correct number of users.
Was this helpful?