nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA Core Audit - User Export - SQL Request

Jonathan Smith

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

Accepted answers

Derek Fields _RightStar_

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

All comments

Derek Fields _RightStar_

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

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

@Derek Fields _RightStar_ Would you happen to have the same code for Confluence?

Daniel Ebers

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

Cheers,
Daniel

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jira-core