Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA Core Audit - User Export - SQL Request

Jonathan Smith
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 13, 2020

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...

  • JIRA CORE Server 8.4.1

1 answer

1 accepted

0 votes
Answer accepted
Derek Fields (RightStar)
Community Champion
October 13, 2020

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
Jonathan Smith
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 13, 2020

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.

Jonathan Smith
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2020

@Derek Fields (RightStar) Would you happen to have the same code for Confluence? 

Daniel Ebers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 24, 2020

For confluence there is a knowledge base article which might be helpful. Please kindly check and let us hear from you.

Cheers,
Daniel

Suggest an answer

Log in or Sign up to answer