Show idle users without assigned issues

[CST JIRA Confluence Admin]

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

Lokesh

[Max MacLeod]

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.

[Deleted user]

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 (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.

Hope this helps!

Thanks
Kalyani

[CST JIRA Confluence Admin]

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.

Lokesh

[Sabyasachi Samal]

Is there any solutions available for this query?