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; } } }

Need a groovy script to extract all users in all orgs for a JSM Project (Jira 10.3)

Normann P_ Nielsen _Netic_

Tried a lot of my old code and what ChatGTP and Gemini offers.

In general the latter two messes around regarding the API's that seems to have changed quite a lot around "OrganizationsQuery" ...

Does anyone have a working script?

Accepted answers

All comments

Mohamed Benziane

Hi,

You can use this api to get all users in a JSM organization:

The Jira Service Management Cloud REST API

Marc -Devoteam-

Hi @Mohamed Benziane

The tags on the question indicate @Normann P_ Nielsen _Netic_ is running Jira on DC, so the provided cloud api option will not fulfil his need.

Marc -Devoteam-

Hi @Normann P_ Nielsen _Netic_

You can use the API endpoint provided for DC, https://developer.atlassian.com/server/jira-servicedesk/rest/v1103/api-group-organization/#api-group-organization

Or a python script, e.g.:

import requests

BASE_URL = "https://your-jira-instance.com"
AUTH = ('username', 'password_or_token')
HEADERS = {"Accept": "application/json"}

# 1. Fetch Organizations
orgs_resp = requests.get(f"{BASE_URL}/rest/servicedeskapi/organization", auth=AUTH, headers=HEADERS)
organizations = orgs_resp.json().get('values', [])

for org in organizations:
print(f"Organization: {org['name']} (ID: {org['id']})")

# 2. Fetch Users for this Org
users_resp = requests.get(f"{BASE_URL}/rest/servicedeskapi/organization/{org['id']}/user", auth=AUTH, headers=HEADERS)
users = users_resp.json().get('values', [])

for user in users:
print(f" - User: {user['displayName']} ({user['emailAddress']})")

Or query the database:

SELECT
org.NAME AS "Organization Name",
u.lower_user_name AS "Username",
u.display_name AS "Display Name"
FROM "AO_54307E_ORGANIZATION" org
JOIN "AO_54307E_ORGANIZATION_MEMBER" mem ON org.ID = mem.ORGANIZATION_ID
JOIN "app_user" au ON mem.USER_KEY = au.user_key
JOIN "cwd_user" u ON au.lower_user_name = u.lower_user_name
ORDER BY org.NAME;

Or Groovy, but can't test this:

import com.atlassian.servicedesk.api.organization.OrganizationService
import com.atlassian.servicedesk.api.organization.UsersInOrganizationQuery
import com.onresolve.scriptrunner.runner.customisers.WithPlugin
import com.onresolve.scriptrunner.runner.customisers.JiraAgileBean

@WithPlugin("com.atlassian.servicedesk")
def orgService = com.atlassian.sal.api.component.ComponentLocator.getComponent(OrganizationService)
def currentUser = com.atlassian.jira.component.ComponentAccessor.jiraAuthenticationContext.loggedInUser

// Define query for all organizations
def orgQuery = orgService.newOrganizationsQueryBuilder().build()
def orgs = orgService.getOrganizations(currentUser, orgQuery).getResults()

orgs.each { org ->
log.info "Organization: ${org.name}"
def userQuery = orgService.newUsersInOrganizationQueryBuilder()
.organization(org)
.build()

def users = orgService.getUsersInOrganization(currentUser, userQuery).getResults()
users.each { user ->
log.info " --> ${user.displayName}"
}
}