How to get the users added to a particular role in Jira on all the projects?

[Mauli]

If this can be done using a SQL query or APIs also?

[Mikael Sandberg · Accepted solution]

Hi @Mauli,

Welcome to Atlassian community.

You can use the REST API to get the members. Here is the documentation for Jira Cloud with an example on how to get it, API group project role, and here is the documentation for Jira Server, api/2/project/{projectIdOrKey}/role   

[Mehmet A _Bloompeak_]

Hi @Mauli ,

Not a SQL or API but if you want to allow any project member to see the users and their roles inside the project you can use Project Role Tab for Jira Cloud app that we developed.