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   

[Markus Hovikoski]

@Mikael Sandberg just found your post and I am trying to achieve a REST call to get certain role and it's members FROM ALL PROJECTS

But when I try that REST call, it only returns the description of the role and not the members. What could cause this. We are using Jira Server.

{
  "self": "https://xxxxx/rest/api/2/role/10040",
  "name": "Support",
  "id": 10040,
  "description": "A project role that represents support."
}

[Mikael Sandberg]

@Markus Hovikoski The API has changed since 2020, you now have to use Get project role for project in order to get the members.

[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.