License reporting incorrect number of users

Still need help?

The Atlassian Community is here for you.

Ask the community

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

  1. Go to  > General Configuration > Users
  2. 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.
  3. After that, your license should display the correct number of users.

Last modified on Apr 29, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.