Generate Report of Project Roles

[Abid Raza]

Hi, I would like to generate a report in which I can have information of all users added in Project Roles in each JIRA Project. 

Can someone assist me here. I am using JIRA cloud?

Thanks

[Mehmet A _Bloompeak_]

Hi @Abid Raza

If you are OK with using a marketplace app, you can try Project Roles - Groups and Users app developed by our team. It introduces an additional tab to the project dashboard named "Project Roles" and displays the project roles and the users/groups assigned to these roles within your project. For more details, you can have a look at the article below:

Getting a Full Picture of the Project Roles in Jira

Hope it helps.

[Aron Gombas _Midori_]

You can do this with our Better Excel Exporter app by exporting the users, see the last column:

See: https://midori-global.com/products/better-excel-exporter-for-jira/data-center/documentation/user-export

(Discl.: it is a paid and supported app developed by our team.)

EDIT: I just realized the question is about Jira Cloud. Although the app is available for Jira Cloud, the user export template is not... Jira Cloud has a built-in user export feature, but that unfortunately doesn't export project roles.

[Abid Raza]

That's correct!! JIRA Cloud has the feature to export Users details but not Roles which is my requirement. We need to generate a report in which we need to have Users information in all Roles under each Project. 

Is this possible through any Script we can execute to hit JIRA Cloud API? 

Thanks

[Aron Gombas _Midori_]

Having a look at the Jira Cloud REST API, you could do this:

1. Get all projects:
   https://developer.atlassian.com/cloud/jira/platform/rest/v2/api-group-projects/#api-rest-api-2-project-get
2. Iterate over the previous, and get all project roles defined for a given project: 
   https://developer.atlassian.com/cloud/jira/platform/rest/v2/api-group-project-roles/#api-rest-api-2-project-projectidorkey-role-get
3. Then get the details of each project role (where details include the groups and users with the given role in the given project):
   https://developer.atlassian.com/cloud/jira/platform/rest/v2/api-group-project-roles/#api-rest-api-2-project-projectidorkey-role-id-get

From these, you will have the result you're looking for.

[Abid Raza]

This is the approach we are currently doing to achieve this and I think there is no other way except this.

We get this report in a text format. By the way, on a side note, Is this possible we can get this information in a csv or excel for the reporting purpose or do we need to make csv manually?

I really appreciate your help here.

Thanks

[Aron Gombas _Midori_]

Our Better Excel Exporter app allow creating export templates that can run Groovy scripts.

So, you could write a Groovy script that makes these REST API calls, then returns the result to the Excel template which renders a spreadsheet from that! It should be fairly straightforward.

We have a "project export" template among the default ones. You could make a copy of that (.xslx plus the .groovy) and customize the copied one.