Would anyone mind supplying the SQL to export active JIRA users?
Seems simple to me but the users in jira-core-users do not add up to what is shown for my license count...
Try this:
select a.group_id, a.license_role_name, b.child_name
from licenserolesgroup a
inner join cwd_membership b on a.group_id = b.parent_name
inner join cwd_user c on b.child_name = c.user_name
where c.active = 1
Thank you. Our setup is a little funky so it looks like our group jira-core and jira-core-users both have application access.
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Derek Fields (RightStar) Would you happen to have the same code for Confluence?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For confluence there is a knowledge base article which might be helpful. Please kindly check and let us hear from you.
Cheers,
Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.