How do you determine where a group is used?

[Chad Ellison]

We are looking to streamline our groups. This will involve deleting many of them that we believe to be redundant. How can I determine the impact of deleting a group? I know that I can look at the View Group screen and JIRA will display which Permission Schemes, Notification Schemes, Issue Security Schemes and Saved Filters are associated with the group; however, this does not say if a group is associated with a default group as part of a role assignment for a project. This can be found by looking at each project, but this is fairly laborious.

Is there some database query (or queries) that can be run that would identify group usage?

[Christian Czaia [Decadis AG]]

Hey,

the following query returns the projectrole, the group in that role and the project using that role:

SELECT r.roletypeparameter, pr.name, p.pname as project FROM jira_prod.projectroleactor r
left outer join project p on r.pid = p.id
left outer join projectrole pr on r.projectroleid = pr.id
where roletype = "atlassian-group-role-actor";

Cheers Christian