SQL query to know add-on usage in Jira

[Stuti Golwala]

Hi,

I am looking to have a SQL query that can list the project/s a particular add-on is used.

Eg.: I want to know how many or which project/s is/are using the add-on "Adaptavist ScriptRunner for JIRA"

Any help is appreciated.

Thanks!

[Nic Brough -Adaptavist-]

You can't do this in general.  Apps can add so many different functions, to so many different places, you don't stand a chance of doing it with SQL.

And you can't answer "what plugin is used by what project" for many because they're not project apps.

If an app adds a workflow function, yes you can scan the workflows for it, then read the workflow schemes to see which projects use it, (the SQL for this is slow and ugly and it's far faster to do it in the UI as you won't have to work out what the raw data is telling you), but an app that adds project fields is going to need totally different SQL, and one that adds user profiles can't be tied to projects at all.

You need to go over each App separately, work out what it provides and how to search for it individually.

Some apps can be checked more easily - ScriptRunner has a built-in "script registry" script which lets you look at all the scripts configured for it, that's a starting point for it.

Your best approach here is:

1. Ask your users what they think they use
2. Have a swift look at where Apps might be used
3. For any app you're uncertain of, go back to the users again and ask if they use it (you may need to explain its functions briefly)
4. Last resort - disable an app and see who screams at you

[mfabris]

Hello Stuti

I suppose you mean which Workflows use Scriptrunner in a Transition?

Scriptrunner can be used for a lot of things (automations, running scripts that do bulk actions etc).

If you want to find out if the plugin is used in workflows, you can export the workflow in XML and check the code, you will find if the plugin is used.

If you want to do this operation in bulk, you can use an SQL query from the server (see for example the technique used here: https://community.atlassian.com/t5/Jira-questions/Find-which-workflows-that-uses-a-specific-validation-plugin/qaq-p/455919).

I used this once because I wanted to deactivate a plugin and thanks to this query I found a lot of workflow where it was used, but not all. It was still necessary to do some tests and wait for the users to report the cases that were not coming up with the query.

As an alternative solution if you are not familiar with running queries in the database (or you do not have a staging environment, which would be advisable for these situation) you can consider a plugin that does a lot of things for admins, including solving the problem you have now. (see for example Admin Toolbox for JIRA)

I hope this helps!