SQL Query to retrieve all Inactive workflow schemes Inactive workflows

[Chander Inguva]

Hi All,

           As a part of clean up process, I was looking at deleting Inactive workflow Schemes and Inactive Workflows.

I know that we can delete it from UI, but it takes longer time. I wonder which table will have this information.

Tried looking into these tables

dbo.workflowschementity
dbo.workflowscheme
dbo.nodeasscociation
dbo.jiraworkflows
dbo.jiradraftworkflows
dbo.draftworkflowschementity
dbo.draftwokflowscheme

Please help me with SQL Query which saves a lot of time.

Thank You

Chander

[Casper Hjorth Christensen]

Hi @Chander Inguva 

Did you ever find an appropriate SQL solution?

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Consider using deleteWorkflow and deleteWorkflowScheme from JIRA CLI. It would be safer than doing database operations.