I would like to list users counting towards the Confluence license. I'm using Confluence 5.0.2 and JIRA 6.0.4 with Crowd directory and MySQL database. Unfornately common SQL solutions do not list what I want.
It sounds like you saw our knowledgebase article, as your question has nearly the same title: How to get a list of active users counting towards the Confluence license
The queries on that page should work for Confluence 5.0.2, and they sort the results by directory so you should be able to use that SQL to get the active users counting toward your license from a JIRA user directory or from a Crowd directory.
Please let me know how the queries on our knowledgebase article do not list what you want, or whether they do work for your case.
Perhaps you have nested groups or usernames that are the same in the Confluence Internal and JIRA User Directories.
Please use the UI to investigate further. Users with permission to use Confluence count against the license. If you remove the extra users from the groups that are granted permission to use Confluence, they will no longer count against the license.
The UI does not present a flat list of users that count against the license. Since only the groups listed under Global Permissions count against the license, those are the only groups you need to examine to get a list of users that count against the license.
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 view the groups via Confluence Admin > Groups to reveal their members. To see which directory the users are in, click on the username in Confluence Admin>User Management
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Community, Jessica here from the Confluence Product Marketing team! July’s community challenge is all about sharing pictures — and as an extension of our first post on what ...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs