Confluence license

[Kapil M Sharma]

I bought 10 Confluence Licenses and I have only utilized 8, but confluence is showing me the following info:

• Users allowed by license: 10
• Current active users: 10

In my group member list I see 7 users only plus I have one admin account.  I need to add two more users, please help.

Thank you,

Kapil 

[Kapil M Sharma]

We are using server version and I can see 8 user listed in UI, but the count says 10 and if try to add more users, it interrupt other's access. 

Thanks,

Kapil 

[Brant Schroeder]

Are you using Jira to manage your users permissions or is this a stand alone instance?

[Kapil M Sharma]

I have Jira and Confluence on the same server, but Confluence is using separate user directory. I have 25 users licence in Jira and 10 in confluence. 

[Brant Schroeder]

Do you have access to the DB?  If you do you will want to run the SQL Ann pointed out in her post above.  You can find the SQL here:

https://confluence.atlassian.com/confkb/how-to-get-a-list-of-active-users-counting-towards-the-confluence-license-298978076.html?_ga=2.136068465.195546107.1517241589-589419804.1510933849&_gac=1.238807348.1513614759.EAIaIQobChMIt_KBrP6T2AIVg6DsCh01QwLQEAAYASAAEgIdBvD_BwE

[Kapil M Sharma]

I did not utilize DB to store user info. 

[Brant Schroeder]

When you installed Confluence did you just use the embedded database? If so you can access it using the following documentation and then query the tables listed above. https://confluence.atlassian.com/doc/embedded-h2-database-145098285.html

[Brant Schroeder]

Are you using Confluence in the cloud? If the answer is yes you will want to check how many users you have assigned in to different applications.  You can go to Settings > User management > Manage applications to see counts and see who is assigned.

[AnnWorley]

Hi Kapil,

I would like to share: How to get a list of active users counting towards the Confluence license

Confluence's license count is based on Global Permissions. Users will count towards the license in the following ways:

• If the user is a member of a group that has global permissions to use Confluence

• If the user is individually granted global permissions to use Confluence

Within the UI, you can get a listing of groups and users that are assigned Global Permissions by navigating to Confluence Admin > Global Permissions. You can find the groups via Confluence Admin > Groups to reveal their members.

If you can't find the users in the UI, the article I shared has SQL queries to investigate further.

Thanks,

Ann