Query the database to find where JMWE is used

[SMAtlassianMber]

Is there a quick way using microsoft sql server to find out where JWME is used in active workflows? I would like to avoid searching inside each workflow XML individually.

[David Fischer]

Sure, just use the following two SQL queries:

select workflowname from jiradb.jiraworkflows where DESCRIPTOR like '%jmwe%';
select PARENTNAME from jiradb.jiradraftworkflows where DESCRIPTOR like '%jmwe%';

[SMAtlassianMber]

That worked perfectly. But Is there a way pull just those post functions or validators for each workflow without manually sorting through the descriptor? 

[David Fischer]

Not from SQL I'm afraid.

However, you could do the same search in the entities.xml file inside a Jira backup (ZIP) file. This will make it much easier to see the actual JMWE extension definitions.

[SMAtlassianMber]

Sound good. I will use the zip file. Thank you for the suggestions.