License reporting incorrect number of users
Platform Notice: Data Center and Cloud By Request - This article was written for the Atlassian data center platform but may also be useful for Atlassian Cloud customers. If completing instructions in this article would help you, please contact Atlassian Support and mention it.
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):
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.
Last modified on Jan 14, 2025
Powered by Confluence and Scroll Viewport.