Get all dashboards with plugin

[adin buld]

Hi!

I have a sorta odd task, my company needs to know how many people use one of our plugins. It basically helps to create diagrams of logged work and that's it. I need to get a number of dashboards, where this plugins is used. Guess it my be done via DB queries.

We are using Jira 8.1 Server with Servicedesk in AWS environment.

Thanks in advance.

[adin buld · Accepted solution]

One of my colleges made this masterpiece! With this query we retrieved all users, that uses the specified plugin:

(insert it in mySQL, after you selected the Jiradb)

SELECT pp.username 'Username' FROM `portalpage` pp INNER JOIN `portletconfiguration` pc ON pp.id = pc.portalpage where pc.gadget_xml like 'rest/gadgets/1.0/g/com.PLUGIN_MARKET_ID%' GROUP BY pp.username;

Hope this will help sometime someone :)