Search workflows for deactivated user

[Jennifer Kelley]

I am looking for a way to seach all my workflows for deactivated users.

Specifically, if I have a termed employee and deactivate their JIRA account, how can I find all workflows with a post funtion that assigns the issue to that person?

I know that I can export an individual workflow to xml and then search for the user name.  I don't want to do this for each workflow.  I am hoping to find a way to just search all workflows.

I would settle with being able to export all workflows to xml at once.  Is that an option?

I am having trouble even finding google results on this topic.

[Bhushan Nagaraj]

Hi Jennifer,

Workflows are stored as xml in the database. You can query the database directly and parse the xml content.

Look up jiraworkflows table on the database.

select * from jiraworkflows;

The xml is stored in the descriptor column.

Thanks

Bhushan