How to get a list of users per project role?

[F A]

In my JIRA instance there are numerous project roles that are not linked to any scheme or workflow. However, what the "view usage for project role" window does not show, is how many users have that role assigned.

I want to avoid confusion for my end-users. If any users are assigned to unused project roles, I would like to properly migrate them to fitting project roles.

EDIT: I am a Jira Administrator. Not a Jira System Administrator, so I do not have full access to the database.

[Ahmet Kilic]

Look at the Atlassian Dock below.

https://confluence.atlassian.com/jirakb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-server-705954232.html

[Sreenivasaraju P]

Hi @F A

PLease refer below link, SQL query mentioned in this thread may help you.

https://community.atlassian.com/t5/Jira-Core-questions/MySQL-query-to-list-all-project-roles-based-on-a-project/qaq-p/1137182

[F A]

Thanks for your swift response. Unfortunately I am a Jira Administrator, not a System Administrator and I do not have access to running SQL queries in the database directly. I have updated this in my post, sorry for the confusion.

[Sreenivasaraju P]

Alternatively you can try with script. Please refer

https://community.atlassian.com/t5/Jira-questions/Show-a-list-of-projects-and-the-users-roles-of-those-project-on/qaq-p/1136578