Could someone help with a query to extract all the users in a particular role in a Jira project. Also help me with the extract of all the users in a group. Can I get the Full Name and the user name in the output.
can you try this Database query
select u.user_name , u.display_name, u.email_address from
cwd_user u inner join cwd_membership g
on u.id = g.child_id
where g.parent_id = XXXX
order by u.user_name;
XXXX - replace with the group id you wanted to list, you can get the id of the group from the below (cwd_group) table.
cwd_group will contain the Group Id and info about the group,
cwd_membership table will contain the User and group mapping.
cwd_user will contain the list of users created in jira
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs