JIRA Server: Change name of user group / how to change Agile Board Admins using SQL

[Dirk Bromberg]

Hello,

to move to cloud we need to change a few user groups on server.

This is working for stuff mentioned here:

How to rename a group in Jira | Jira | Atlassian Documentation

But what is missing:

Usage of groups in agile boards, as administrators. Is there a sql table for this?

Thanks for help!

[Dirk Bromberg · Accepted solution]

Okay, found it myself, here is the query to the board admins table:

SELECT
ba."KEY" AS "Group",
rv."NAME" AS "Board"
FROM
"AO_60DB71_BOARDADMINS" ba
LEFT JOIN "AO_60DB71_RAPIDVIEW" rv ON ba."RAPID_VIEW_ID" = rv."ID"
WHERE
ba."TYPE" = 'GROUP';

[Sanjen Bariki]

Hi @Dirk Bromberg ,

Welcome to Atlassian community!

Please find the below link to see the usage of group in jira as possible.

• Identify group usage in Jira 

In Jira, Currently UI only show when a group is used in:

• Permission Schemes
• Notification Schemes
• Issue Security Schemes
• Shared filters

Please find the below featuer ticket for this.

• JRASERVER-36740 

From the databse sql to get the list from DB, Please find the same community questions responded by the Atlassian team.

• Projects and agile boards stored in the database 

Hope it will help you.

Regards,

Sanjen

Don't forget to hit the answer button If it helps you😊.

[Nic Brough -Adaptavist-]

@Sanjen Bariki 

Please stop using AI to answer questions.  LLMs do not understand the software, nor the question, and they consistently generate really very poor answers such as this.

If you do not stop, it is likely that the moderators will ban you.

[Sanjen Bariki]

Dear @Nic Brough -Adaptavist- ,

Sorry to say.

This is not generated by AI this is what I got from the q.s.

You can't say this answer from AI, why are you always trying to say this is from AI. If you have any problem then you can correct me but I can't accept this is generated by AI.

SORRY FOR THIS

Note :- I just noticed the q.s changed now and Before the qns. This q.s was different related to DB.

Regards,

Sanjen