Hey Brad,
Confluence's license count is based on Global Permissions. Users will count towards the license in the following cases:
- If the user belongs to 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 list of users and groups that have Global Permissions and will count against your license by navigating to Confluence Admin > Global Permissions. You can click on each group individually to reveal their members.
Also, the following query will return users that belong to a group which has global permissions:
SELECT DISTINCT u.lower_user_name
FROM cwd_user u
JOIN cwd_membership m ON u.id = child_user_id
JOIN cwd_group g ON m.parent_id = g.id
JOIN spacepermissions sp ON g.group_name = sp.permgroupname
WHERE permtype='USECONFLUENCE' AND u.active = 'T';
To get your user count down, the following guidelines may be helpful:
- If you have more than one directory, ensure that the same user does not exist in multiple directories.
- We recommend that you allow only particular groups to log in to each application, rather than entire directories.
- Note that a mapped application can 'see' all users in a directory, even if not all of them can log in to the application. For example, a Human Resources application might be mapped to your entire Active Directory server, but only the HR group is allowed to log in to the application.
I hope it helps!
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.