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
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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