How to know if a JIRA plugin is being used

[Adolfo Casari]

Hi,

I have a plugin that provides gadgets. However, I don't if this plugin is actually being used by some users or not.

Is there any query where I can find if there are instances of gadgets provided by this plugin?

Thanks in advance,

[Aron Gombas _Midori_ · Accepted solution]

Gadget types are identified by a FQN like string like "com.whatever:mygadgetname".

If I were you:

1. Try to find which database table contains the dashboard to gadget instances relations
2. Filter through that for gadget type you are after

 I don't know the details of the underlying database schema, and the relations may be more complicated than what I suggest above, but the method I suggest should work regardless.

[Adolfo Casari]

Actually I got a tip  and this do the trick:

SELECT portalpage, gadget_xml, count(*) FROM portletconfiguration WHERE gadget_xml LIKE '%YOUR-PLUGIN-KEY%' GROUP BY portalpage, gadget_xml;

[Aron Gombas _Midori_]

Cool, then mark this answer with the checkmark so that future users will find the solution.

[Tahmina Khan]

I have attempted to use the above query to find what plug-ins are being used but unable to. Can you explain how that query works?