Is there a SQL query that will pull all information on JIRA Dashboards?

Pineapple

For example, I am trying to identify dashboards using a specific gadget and the filters as well as pulling out the below fields in the same query?

• Dashboard Owner user name,
• Created On,
• Created by,
• Last Modified On,
• Last Modified By
• last viewed date

I tried finding some related SQL query questions here but I do not see any that is getting information on the dashboard. So, if anyone can point me in the right direction that will be helpful as well! Thanks!

Danut M _StonikByte_

Hi @Pineapple 

To determine the gadgets usage in your Jira Server / Data Center instance, you can run this SQL query on the Jira database:

SELECT portletconfiguration.gadget_xml, portalpage.pagename, portalpage.id, portalpage.username
FROM portletconfiguration INNER JOIN portalpage
ON portletconfiguration.portalpage = portalpage.id
WHERE portletconfiguration.gadget_xml LIKE '%com.stonikbyte.great.gadgets%'

In this example, the LIKE condition looks for the gadgets specific to our Great Gadgets app developed by StonikByte. But, you can replace that with any other text, specific to other app or gadget, taken from the XML link.

This returns a list with the gadget identifier (gadget_xml), the name (pagename) and the identifier (id) of the dashboard where the gadget is located, and the user who added the gadget to dashboard (username).

Hope this helps. 

Danut.