Get all the groups with 0 members (JIRA DC)

Question

Hello Community,

Is there any option to get the groups list with 0 users, as we are migrating the JIRA DC instance to Cloud we are optimizing the Instance prior Migration we are having nearly 14000 groups for optimization , i have traversed through the KB articles but not able to find any results we are using Jira Version : 9.4.12 and Oracle database can anyone help us solve this query.

Thanks & Regards,

Ganesh

Ganesh Choubey D · Answer

Hello @Mirek

This particular Instance is active from last 5 years and group optimization has not been done for many years.

This is a banking sector project  so they have opted for the group creation for each branch which has led to this huge instance of 14000 groups, one of the huge problem is they are having more than 30% empty groups looking for some scripting refernces still for the group usuage.......

Thanks & Regards,

Ganesh

Mirek · Answer

Yes I agree that is why I am suggesting automating this in some way using a script that would run over the night and give you results later.

Overall just curious.. How you reached almost 14000 groups.. Was this created manually or automatically somehow?

Ganesh Choubey D · Answer

Hi @Mirek

Thanks for the suggession i was able to get my solution by running a script.

Ref Link:  https://community.atlassian.com/t5/Jira-discussions/Groovy-Script-to-list-all-groups-and-their-respective-members/td-p/680689

Now it is somewhat managable and yes i will make sure to see the group usuage for the groups,but traversing through database for each group usuage could be very complicated looking for some wrrkarounds.

Thanks & Regards,

Ganesh