Our new Appfire Documentation Space is now live!

Take a look here! If you have any questions please email support@appfire.com

How to get the JSU usage statistics for Jira workflows

Owned by Kinnera Siriki (Unlicensed), created
Last updated: Dec 04, 2020
1 min read

This article helps you to get the list of workflows where the JSU conditions, validators, and post functions are added within your Jira instance that is hosted on the Server or Datacenter and uses the JSU app.

Use cases:

  • To identify usage of JSU post functions and conditions within the Server/Datacenter instance before performing a migration to Cloud

  • To get the usage of the JSU within the active/inactive workflows

  • To get the usage of the JSU with a database query

Instructions

Use the following SQL query in the database to get the list of workflows:

select * from jiraworkflows where descriptor like '%com.googlecode.jsu%' or descriptor like '%ch.beecom.jira.jsu%';

 The output result is displayed as follows:

The above workaround is applicable only for Jira Server and Data Center, but not for the Cloud instances.