How to find the unmapped groups in Jira??

Abinaya TDK January 19, 2014

How we can find unmapped groups (i.e groups which are not mapped with any project)???

Please suggest some query to find the same.

2 answers

1 accepted

0 votes
Answer accepted
Tiago Comasseto
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 19, 2014

Hi there, in this page you have a query to retrieve a list of Projects where a particular group has any permissions.

I hope it helps.

Cheers

Abinaya TDK January 20, 2014

Hi Tiago,

I need group names which is not mapped with any permission scheme.

Please help me tom get group names. I dont need project name as output.

Kindly help me to make a query to fetch the groups which is not mapped with any permission scheme.

Matt Reiner May 27, 2014

Tiago, your link seems to be broken. Is there any way you could repost this solution?

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 19, 2014

With difficulty, because you're looking for negative data.

What you probably need to do is build a list of what groups are used and then subtract it from the list of all groups. You'll need to look through all the project roles, all the permission schemes, all the notification schemes, all the security schemes, any group field data, all the filters and all the gadget definitions to find out where groups are being used. I can't think of an easy way to do any of this in one go.

Abinaya TDK January 20, 2014

Please help me to find the groups which are not mapped with any permission scheme..

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 20, 2014

Again, there is no way to do this because you can not search for a negative value.

You need to

  • get the full list of all groups
  • search for all groups that are used
  • Subtract the used groups from the full list

Some extra points here

  • You can easily modify Tiago's SQL to return groups in use instead of projects
  • Groups are not ONLY used by projects, they're used in many places. Just because you find a list that are not used in permissions, doesn't mean it's ok to delete them
Abinaya TDK January 20, 2014

In that query i am retrieving project name as the output.

But i need to find the group name which is not mapped with any permission scheme.(ie. Group names i should get as output).

Abinaya TDK January 21, 2014

Hi All,

Please tell me how to link permission scheme with groups with the help of sql query..

This is to fetch the group which is not mapped with any of the permission scheme.

Kindly help me on this ASAP

Abinaya TDK January 21, 2014

Hi Nic,

In nodeassociation table there is no link between group and permission scheme.

So , how i can make a query ???

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 21, 2014

Again, get the list of groups, then subtract the list of groups in use from it.

You also need to think through what you mean by "groups used".

If you read the permission scheme table, you can extract lines where you've got "allow permission to group X", but that doesn't cover the use of groups via role. Or group-picker custom field.

It should be easy to change Tiago's SQL to something that will get you the groups in the schemes though.

Suggest an answer

Log in or Sign up to answer