Team Members Report

[Harish Kumar]

Hello I have various projects in my on premise Jira and would like to create a report where i can see which team members and their role (Dev/test) are working on projects. 

So could you kindly help me with JQL query or which report should i create.

[Trudy Claspill · Accepted solution]

Hello @Harish Kumar 

What is your definition for "working on a project"?

• Does that mean the user is currently the Assignee on an issue?
• Or does that mean the user is assigned to a Project Role in the project?
• Or does that mean both - the user is assigned a Role and is assigned to an issue?

Are "Dev" and "test" Project Roles in your project?

What do you want the report to contain? Are you looking just for the list of people and their Project Role(s)?

[Harish Kumar]

@Trudy Claspill : Thanks for your reply and queries in details. 

I was looking for the list of people and their Project Role(s)?

It means both  - the user is assigned a Role and is assigned to an issue.

[Trudy Claspill]

What is your hosting type? Are you working in Jira Cloud or Jira Server/Data Center?

If your URL is similar to the following, you are working with Jira Cloud.

https://yourCompany.atlassian.net

You can use the built-in functionality to retrieve a list of issues where the Assignee field is not empty. You can display the results of that filter in a Jira Dashboard using the Pie Chart or Two Dimensional Issue Statistics gadget and grouping by Assignee to get a more condensed list showing the people assigned to issues.

There are limits to the number of issues that the issue search function will return, depending on your hosting type.

The following article might be helpful to you for getting users assigned to roles, if you are using Jira Server/Data Center only.

https://confluence.atlassian.com/jirakb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-server-705954232.html

Otherwise there is no built in report for that. You would have to look for a third party app that could help you extract that information.