Hi, I've hudge problem to get correct amount of licences in our instances (Jira/Confluence). We manage users of Confluence in Jira directory. So when I try to filter anyone with ,'confluence-users' group, I get 214 results. I have one Admin account for both instances, plus one admin-confluence local account. When I try to check licences on the Confluence side, I get 249 used licenses. Using postgresql query, I get the same result.
SQL isn't the right way to look at this.
Log into Confluence as a full admin, and go to Admin (general) -> Security -> Global permissions.
Look at the groups and individuals who have "can use". I suspect you've got more than just "confluence users" in there.
I had a bad feeling that was the case, but it's been the answer arounf 75% of the time this question comes up.
The next one is a long slog - you'll need to look at the full list of users and identify the ones (although it's likely you only need to find the first one to find out the underlying cause)
However, before trying to do that via the UI, if you are on Confluence 7.0.2 or above and can get to your logs, there is a trick that can help.
Note - this can be slow and cause heavy load, so do it when it is quiet. And remember it's going to dump personal data (user names) out into a system log, unencrypted and in plain text, so there might be security and privacy risks in this.
Being on 7+ and having this has made it a LOT easier - the list that comes out in the log can be dumped into a spreadsheet alongside "members of groups X, Y and Z" and then a lookup function used to match the two sets and highlight where they don't match!
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events