Bulk Edit Groups in Jira
When managing group membership directly from the group rather than through the User Browser, there is a system limitation on the number of users you can add to a group at a time of 100, which limits the amount of users that can be edited at one time. To add more than 100 members into the group at once, they need to be extracted from the database with SQL.
Identify the User Directory the users belong to:
SELECT id, directory_name FROM cwd_directory
Select all the users from that directory:
SELECT 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.