Show idle users without assigned issues

CST JIRA Confluence Admin September 5, 2018

We would need to generate a report of idle users who are part of a project, but not assigned with any issues

This is required for our management for accountability & release them if not required

This is pretty important requirement for us to track these users & ensure to match unassigned issues with idle users.

Somehow we are able to get such report for assigned users via " Issue Statistics " gadget, but not sure if we can have reverse of it.

Any ideas & thoughts, much appreciated.


Thanks much in advance


2 answers

0 votes
Max MacLeod August 4, 2021

Seems like a fundamental limitation. With Adaptavist ScriptRunner a query can show the count but again this is by individual:

project = FOO and statusCategory != Done and issueFunction in aggregateExpression("assignee.count(‘username')")

Will give an output prior to a list of issues, e.g.

Aggregate data value: 3

A better - paid - alternative is eazyBI. That includes a sample issue report which shows various graphs types of open issue by assignee.

0 votes
Deleted user September 6, 2018

Hi @CST JIRA Confluence Admin,

As you probably understand, 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 ( 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.

Hope this helps!


CST JIRA Confluence Admin September 6, 2018

Hi @[deleted],

Appreciate your response

But creating 1 issue for each of our 516 users, just to find out seems not much practical

Also, we need this for reporting, not as a one-time/ad-hoc requirement

Maybe there's any possibilities by querying via groovy/SQL !!

Thanks anyways.


Like # people like this
Sabyasachi Samal March 5, 2024

Is there any solutions available for this query?

Suggest an answer

Log in or Sign up to answer