Showing more number of licensed users than actual

Question

Hi, I am trying to get the user details who are consuming the jira license. When looking at the screen shot 1, it shows 1062 users , but when clicking on it, it's showing 1078 users? any one know why?

Venkata_Guntuku · Answer

No, that did not work. It just gave 232 users details.

Tom Lister_fo1j4e · Answer

Hi

try this for users and groups

SELECT 
cwd_user.id, 
cwd_user.user_name, 
cwd_user.email_address, 
cwd_user.active, 
cwd_directory.directory_name, 
cwd_group.group_name, 
cwd_group.active
FROM 
cwd_user, 
cwd_group, 
cwd_membership, 
cwd_directory
WHERE 
cwd_user.directory_id = cwd_directory.id AND
cwd_user.id = cwd_membership.id AND
cwd_membership.parent_id = cwd_group.id;

Venkata_Guntuku · Answer

@Tom ListerThanks for replying to the post. We do not have LDAP connection instead we have crowd server from where the users will be authenticated from. By the way, I wanted to get the list of user's names and email addresses  who are actually consuming licenses. Is there any query , we are using MySQL.