How to find resources without any task

[Gautam De]

I run a team of 14 members.

I am trying to make a report using JQL to show members of my team who has no Jira issue assigned to.

Could you kindly suggest a solution?

Thanks,

Gautam De

[Rilwan Ahmed]

Hi @Gautam De ,

Welcome to the community! 

One more turnaround.
You can make use of Jira pie chart/Issue Statistics gadget in your dashboard. It can display list of users with number of ticket assigned to users.

If any user has 0 tickets assigned, then it will not display their name. This way you can come to know who has the assigned tickets. 

[carlosughini]

Hi Gautam,

Welcome to the community!

Unfortunately, JQL is not a possibility as it helps you to find issues without Assignees, but not the other way. Two-dimensional filter gadget will be a good way to understand the workload amongst your team members, at a glance.

There is a workaround that was provided in an earlier community thread (https://community.atlassian.com/t5/Jira-questions/JQL-Can-I-list-users-who-don-t-have-any-issues-assigned-to-them/qaq-p/384607) as to how we get to see the resources with no issues assigned. Here, it is suggested for one dummy issue to be created and assigned to each of the participating resources. The two dimensional filter gadget should be created with Filter: "assignee in (your team members)", assignee on the X-axis and project on Y-axis and show the Total. Any assignee with the total showing as 1 should be identified as a resource without any issues assigned, in the scope of the Project in context.

Please give it a try and let me know if it helps.

Kind regards,

Carlos