nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Dirk Bromberg

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';

All comments

Sanjen Bariki_rtm841

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_rtm841

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

Dirk Bromberg

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';

Nina Gholizadeh-Afschari_mgm_

Hi @Dirk Bromberg

I came across your question about the missing feature, and I believe this might be especially relevant now, considering the ongoing migration to the cloud. With that in mind, I wanted to let you know that our app Group Master for Jira (Data Center) could provide exactly the functionality you're looking for.

https://marketplace.atlassian.com/apps/1236395/group-master-for-jira?hosting=datacenter&tab=overview

And another advanced group management capabilities:
View group usage across Jira
Edit group names for clarity
Move or copy group members easily
Replicate or migrate group usage
Delete groups and clean up associated data

I think it could be a great fit for your needs during this transition. If you're interested, I'd be happy to share more details about how our app can support you in the cloud environment!

Cheers,

Nina

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-core