get the right list from database

unknown

Hi,  we have some issues to get a query to search for jira software user and get a list of current jira software user for a review. 

mysql database running for jira 7.x

would you please help ? 

we did see all the users in cwd_user, but don't know what to filter in order to get only jira software users

Nic Brough -Adaptavist-

Check cwd_membership, after looking at your application permissions (that will tell you what group(s) have Jira-software-users)