How to identify the dashboards using Gauge Gadgets for Jira

Owned by Hua Soon SIM [Akeles]
Last updated: Dec 11, 2017 by Stella
1 min read

You can use the following SQL to identify the pages

select p.id as dashboard_id, p.pagename as dashboard_name, p.username as dashboard_author, pc.gadget_xml
from portalpage p, portletconfiguration pc
where p.id = pc.portalpage
AND pc.gadget_xml like 'rest/gadgets/1.0/g/com.akelesconsulting.jira.plugins.GaugeGadge%'

Then you can load the dashboard using the format 

<Jira Base URL>/secure/Dashboard.jspa?selectPageId=<dashboard_id>

An example will be https://jira.atlassian.com/secure/Dashboard.jspa?selectPageId=19921 with

Jira Base URL = https://jira.atlassian.com

dashboard_id = 19921