Identify usage of specific gadgets in Jira Dashboards

This article provides a SQL query to help Jira administrators identify the usage of "Pie Chart" and "Date Bar Chart" gadgets in Jira Data Center (DC) dashboards.

\uD83D\uDCD8 Instructions

1. To find out which dashboards use the gadgets from Rich Filter app and how frequently they are used, run the following SQL query against your Jira DC database:

   SELECT pp.pagename as dashboard_name, pc.gadget_xml, count(pc.gadget_xml)
   FROM portalpage pp
   JOIN portletconfiguration pc ON pp.id = pc.portalpage
   WHERE pc.gadget_xml LIKE '%com.qotilabs.jira%'
   GROUP BY pp.pagename, pc.gadget_xml;

   

2. Copy the name of the gadgets from the gadget_xml to identify the usage of those specific gadgets. In this case, consider the Date Bar chart, Pie Chart as an example:

SELECT pp.pagename AS dashboard_name,
       pc.gadget_xml,
       COUNT(pc.gadget_xml) AS gadget_count
FROM portalpage pp 
JOIN portletconfiguration pc ON pp.id = pc.portalpage 
WHERE pc.gadget_xml LIKE '%rich-filter-date-bar-chart-gadget.xml%' 
   OR pc.gadget_xml LIKE '%rich-filter-pie-chart-gadget.xml%'
GROUP BY pp.pagename, pc.gadget_xml;