Need User Report for Entire JIRA instance based Project role

Question

We need to generate a user report based on the project role. How can we  get this report

Navarambh Software - Gmail · Answer

Hi,

If you use Power BI or Tableau, you can import this data using one of our apps:

https://marketplace.atlassian.com/apps/1219072/aio-power-bi-connector-for-jira?hosting=datacenter&tab=overview

https://marketplace.atlassian.com/apps/1214641/aio-tableau-connector-for-jira?hosting=datacenter&tab=overview

Documentation:

https://aioreports.atlassian.net/wiki/spaces/APBCFJ/overview

https://aioreports.atlassian.net/wiki/spaces/ATCFJ/overview

Regards

AIO Support

Akmal Harith · Answer

Hi Prabhakar, in Jira there are no functionalities OOTB which can help you to get user reports.

Are you looking to get a list of users assigned to all the Project Roles available in Jira? You might want to take a look at this KB here which can help you to get that from SQL querying:

* Retrieve a list of users assigned to project roles in Jira server

Hope this helps!

Best regards, 
Akmal Harith | Atlassian Support