nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I find all JIRA users without any group assignments?

Darryl Lee

Can anybody think of a way to find all JIRA users that do not belong to any group?

MySQL query would be fine - I just need userIDs. Somebody who worked here before thought that removing all group permissions was sufficient to keep a user "active", but we're finding that unless a user has Assignable and Create Issue (?) permissions, Bulk Changes are getting hung up on these "zombie" users.

My plan, once I get the list, is to use the JIRA CLI to assign these users to an "Ex-employees" group that only has the above permissions.

Thanks!

Accepted answers

Henning Tietgens

You can use the Script Runner plugin and the following script:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.user.util.UserUtil

UserUtil userUtil = ComponentAccessor.getUserUtil()

result = ''

userUtil.getUsers().findAll{userUtil.getGroupsForUser(it.getName()).size() == 0}.each{ u ->
    result += u.name + "<br>"
}

result

Henning

All comments

Henning Tietgens

You can use the Script Runner plugin and the following script:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.user.util.UserUtil

UserUtil userUtil = ComponentAccessor.getUserUtil()

result = ''

userUtil.getUsers().findAll{userUtil.getGroupsForUser(it.getName()).size() == 0}.each{ u ->
    result += u.name + "<br>"
}

result

Henning

Norman Abramovitz

I believe this is close to what you are looking for.

SELECT U.ID, U.user_name, G.group_name
FROM cwd_user U
LEFT JOIN cwd_membership M ON U.ID = M.child_id
LEFT JOIN cwd_group G ON G.ID = M.parent_id
WHERE M.child_id IS NULL

Darryl Lee

Thanks for the answer Norman, but it was easier for me to just run it from Script Runner.

Darryl Lee

Thanks Henning, this worked like a charm!

Jonas Andersson

Thanks man, exactly what i was looking for.

Daniela Razo_4qcb4e

unknown

I use the suggested Scriptrunner script and get this error:

startup failed: Script20.groovy: 8: expecting '}', found '-' @ line 8, column 90. tName()).size() == 0}.each{ u -> ^ 1 error

I'm not sure why I'm getting an error about the curly bracket "}" at that point. I copied and pasted this script directly into the Scriptrunner script console and ran it.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration