Search for JIRA group usage in Workflows

Svante Gustafsson Björkegren

Hi all,

I am doing some heavy house-keeping in a quite messy JIRA instance. There are tons of groups created and one task is to get a grip on this and minimize the number of groups as much as possible and start using existing LDAP groups and Roles instead.

When viewing a group in the Admin GUI I get a good picture of the group's occurence in Permission Schemes, Issue Security Schemes, Notification Schemes and if any Saved Filters are using the group.

But I haven't found any information about the usage of groups in the Workflows. I did some poking around and found almost immediately a couple of transition validators using jira-groups. Ouch!!!

I guess this may be possible to dig out from the database in some way but I haven't found any tables holding the e.g. validator info.

Is there a way to query the database for a specific jira group name, say: jira-CAB-members?

Any suggestions are highly appreciated!

Cheers,

// Svante

Nic Brough -Adaptavist-

The workflows are held mostly in xml in the database, so I'm afraid it's a case of searching rather large text fields. But not many of them

You could take a backup of the whole system in XML and explore it that way, but I doubt that's any cleaner than the SQL

However, in both cases, I wouldn't search for the groups - I'd go after the validators. The workflow stores it all in a way that says "for this validator, use class X, with parameters Y". So if you know what validator classes you have installed that might be using groups, you may find them a lot more quickly (this probably applies more to XML export and grep...)