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

1. Identify the User Directory the users belong to:

   SELECT id, directory_name FROM cwd_directory;

2. Select all the users from that directory:

   SELECT user_name FROM cwd_user where directory_id = <id from the previous query>;

3. Comma separate them then copy and paste into the User Box:
   
4. Press the  button.