How to bulk add Jira users that belong to a directory to a Jira group
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose of this article
The purpose of this article is to provide a way to extract a list of users that belong to a specific directory via the Jira Database, and to bulk add them to a group via the Jira UI.
Environment
Jira Server/Data Center on any version from 8.0.0.
Workaround
Identify the User Directory the users belong to:
1SELECT id, directory_name FROM cwd_directory;Select all the users from that directory:
1SELECT user_name FROM cwd_user where directory_id = <id from the previous query>;Comma separate them then copy and paste into the User Box:
Press the
button.
Was this helpful?