List of users without issues assigned (Idle users)

[Emil Naghiyev]

I build a Script which shows me a list of users from specific group (Developers) who are not assigned to specific issue types (Subtasks for example) at the moment. In this way, I can observe which users are idle, do not have assigned tasks on them. 

I run this script in Scriptrunner console to find these users. Now I need to somehow show this output in Dashboards, so Scrum team can also observe these results. 

Is it possible to build a scheduler that every morning will run script, write the result to a specific place and show in the Dashboard? 

[John Funk]

Hi Emil,

Were you not able to just create a Filter using JQL? Then you could add a gadget to a dashboard like a Filter Results gadget linked to the Filter. No need to run it every night, it would always be real time. 

What does your script look like? 

[Emil Naghiyev]

But it is not possible to get list of the users without issues via JQL, JQLs are only used to filter issues, not the users. 

[Emil Naghiyev]

I don't let me post the full script here

[John Funk]

Can you save a Filter with the ScriptRunner script in it? 

[Kristian Walker _Adaptavist_]

Is this being done on Jira DC or Jira Cloud? 

If Jira DC you can use the JQL functions in a JQL query in the main search page, if it is Jira Cloud you need to create the filter on the enhanced search page and then call the shared enhanced search filter in a QL query on the main search page.

[Stefan Salzl]

@John Funk , @Kristian Walker _Adaptavist_ 

how would a filter gives users as result? what would be the JQL?

The requirement is about getting users that aren‘t assigned to any issues, hence are „free for work“.

Or did I get anything wrong here @Emil Naghiyev ?

Best
Stean 

[Kristian Walker _Adaptavist_]

Hi Stefan,

You are correct, there is no way to find users who have no issues assigned to them via JQL, and this would need to be done via a script. 

Unfortunately, if this is the case, you won't be able to get the script's output on a dashboard.

A possible workaround would be to make an API call to put the data returned from the script onto a Confluence page. 

I hope this helps,

Regards,

Kristian

[Stefan Salzl]

@Kristian Walker _Adaptavist_ 

exactly, that was my point.

I could also imagine to create a scripted endpoint within scriptrunner to fetch the users and then call this endpoint from whereever (eg. confluence or any other tool u are using for dashboards) to get the data and create a visualization.

Best
Stefan

[John Funk]

Hey @Emil Naghiyev  - Any update?