The results of the query in the link (https://confluence.atlassian.com/display/CONFKB/How+to+Get+a+List+of+Active+Users+Counting+Towards+the+Confluence+License) to get the count of licensed used from DB is different from the count showing in license details page of Confluence.
Why there is a mismatch in the count even if no user are granted individual global permissions?
In UI it is showing as 1554 users and the query result is having the count as 2078.
Please note that we are using both Crowd and Internal directory for user authentication.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG