It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I add everyone with project administrator access in all projects to a new group?

We have created a new group with bulk change authority and we want to add all Project Admins to it. Is there a way to do this without having to manually add them one at a time?

3 answers

1 accepted

0 votes
Answer accepted

Just closing this out. I was able to run the query and then use excel to parse the users. I then copied and pasted them in to the new group. It took a little bit of manual work but the query to identify everyone was a big help. Thanks, Greg

0 votes
AgentSmith Atlassian Team Oct 09, 2013

The fastest way I know of would be as follows:

  • Go to JIRA Admin > User Management
  • Select Groups
  • Click the Bulk Edit Group Members button
  • Select a Group from left hand side then click refresh the group members list just beneath
  • On the far right, for Add members to selected group(s), click the User Picker icon (lower right hand corner)
  • Select or search users from the User Picker

Hope this helps!

Jason, I see how to do that but it still requires manually adding a few hundred users that I have to identify ahead of time. The User picker does not show any details about the users other than being able to filter by group.

So I'm looking for a query or filter I can run to identify every user that is in a project admin role on any project since our intent is to only allow project admins the ability to do bulk edit.

Thanks, Greg

There isn't anything like this in the UI, you'll need to do some ugly SQL if you don't want to plugh through it by hand.

One hint, I hope that it will help you:

1. Prepare sql statement (I don't have time to prepare it now) to get users from administrator role in all projects. You have to cover two cases to get result:

a.) users entered directly in users column

select * FROM PROJECTROLEACTOR where projectroleid=10002 AND roletype='atlassian-user-role-actor';

(10002 is id for administrator role.)

b.) users entered in Groups column
to get groups..
select * FROM PROJECTROLEACTOR where projectroleid=10002 AND roletype='atlassian-group-role-actor';

You need connect groups from roletypeparameter field with groups in CWD_MEMBERSHIP table and with users in CWD_USER table...

2. Group users from both tables to get unique user values from both tables

3. Use jelly script to add users to groups

<JiraJelly xmlns:jira="jelly:com.atlassian.jira.jelly.JiraTagLib">
<jira:AddUserToGroup username="userX" group-name="new-group"/>
</JiraJelly>
You can use excel formulas to multiply sentence "<jira:AddUserToGroup username="userX"group-name="new-group"/>" and fill "userX" values with user values from your user table.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Next-gen

Keyboard shortcuts have arrived for next-gen projects!

...ollected feedback from users around the lack of shortcuts, and we’re here to address that: In next-gen projects, I miss the keyboard shortcuts badly. This is particularly true on the Board, but also i...

146 views 0 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you