List of all users (with/without issues assigned)

Question

Since Jira has a limitation about filter all users (only filter users with issues assigned), I need to list all users and check what are the ones without an issue assigned. I'm thinking that using Script Runner for this would be good, but I don't know how to do it.

Has anybody an idea?

Tarun Sapra · Answer

Hello @Jay Salvay

UserManager is available via componentAccessor

https://docs.atlassian.com/software/jira/docs/api/7.6.1/com/atlassian/jira/component/ComponentAccessor.html

https://docs.atlassian.com/software/jira/docs/api/7.6.1/com/atlassian/jira/component/ComponentAccessor.html#getUserManager--

Using userManager you can easily get list of users or if your users belong to a generic group then you can also use groupManager instead of userManager. groupManager is also available in ComponentAccessor (it's central point to get all managers)

Point is to get usernames via any manager in order to execute the JQL inside the code to check the number of issues returned whether zero or not.

Once you have the user manager you need to do JQL search in code itself

something like

https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/running-a-jql-query.html

or this

https://community.atlassian.com/t5/Marketplace-Apps-questions/How-to-run-JQL-query-inside-Groovy-script/qaq-p/194691

Jay Salvay · Answer

Thank you @Tarun Sapra. I have been tried, but not able to do it. Do you know where I can get an example? I tried googling for my 7.8.1 JIRA version, but I don't get a "UserManager' function: https://www.google.com.ar/search?ei=ChKZW-yRMcaWwASF1oKgDQ&q=UserManager+%28Atlassian+JIRA+7.8.1+API%29&oq=UserManager+%28Atlassian+JIRA+7.8.1+API%29&gs_l=psy-ab.3...7568.10825.0.10959.4.4.0.0.0.0.145.323.2j1.3.0....0...1.1.64.psy-ab..1.0.0....0.YmTWM8ooRPI

Can you please help me out?

Tarun Sapra · Answer

Hello @Jay Salvay

Yes, you can do it via executing a script in the script console, it's easy actually.

Use "UserManager" in Jira api to traverse the users and then for each user execute the JQL in code

"assignee=username"

Then use a list object to collect the names of the users which have 0 results returned for the above JQL. And return this list object from your script.