Is it possible to export list of users with roles of a particular project.

[SHREE MUKKHI R RAJADURAI]

I have a need to export a list of users along with their role, email address and I number for a particular project.
Please let me know your possible workarounds.

[Aron Gombas _Midori_]

You can export your users with their project roles to Excel using the Better Excel Exporter app:

See that information in column "M". You can easily break that value to multiple columns and filter, search, etc.

Try the app free

(Discl. this paid and supported app is developed by our team. Free for 10 users.)

[Petru Simion _Simitech Ltd__]

Hi @SHREE MUKKHI R RAJADURAI ,

If your goal is primarily reporting and exporting project role assignments rather than building a custom solution with REST APIs, SQL queries, CLI scripts, or Rovo, another option is to use a reporting app.

For full disclosure, I am part of the team that built and released  Roles Usage for Jira.

The app provides visibility into Jira project roles across projects and allows exporting the results to CSV, which can be useful when you need to answer questions such as:

• Which users belong to a specific role?
• Which projects use a particular role?
• How are project roles distributed across the Jira instance?

Depending on your requirements, this may be simpler than maintaining custom scripts or API integrations.

I'm curious to hear how many projects you're looking to report on and whether this is a one-time request or something you need to do regularly.

Regards,
Petru

[Ash H_]

Hi @SHREE MUKKHI R RAJADURAI

I'm Ash from Appfire's Expert Services. You can also consider a more automated and repeatable way to handle this without manual scripting, the Jira Command Line Interface (CLI) provides a very effective solution. Based on the public documentation, the app includes specific actions like `getProjectRoleList` and `getProjectRoleActors` that allow you to retrieve this data directly from the command line. You can use these commands to generate a list of all users associated with specific roles in a particular project and then use the `--file` parameter to export that data directly into a CSV file. This is particularly helpful if you need to perform these exports across multiple projects or schedule them as part of a regular reporting workflow, as it bypasses the limitations of the standard user interface. 

Best of luck,
Ash

[Anshul Arora]

Hi @SHREE MUKKHI R RAJADURAI ,

You can ask Rovo to provide you a list of users with role & export it in CSV.

BR,
Anshul

[Arkadiusz Wroblewski]

Hello @SHREE MUKKHI R RAJADURAI 

REST API: Call GET /rest/api/2/project/{projectKey}/role, fetch the actors for each role, and programmatically expand any group actors found.

SQL: Query tables like projectroleactor, cwd_user (where emails are stored), and cwd_membership. Atlassian provides a KB article with template queries for this.

Here some food for thoughts https://support.atlassian.com/jira/kb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-data-center/ 

Best,

Arkadiusz 🤠 ☀️