Querying the JIRA database online

In the previous recipe, we looked at how to view JIRA log files online, which is a very convenient way to troubleshoot problems. In this recipe, we will continue with this by looking at how you can run queries against the JIRA database from the JIRA UI directly.

Getting ready

For this recipe, we need to have the JIRA Home Directory and DB Browser add-on installed. You can download it from the following link and install it with the UPM:

https://marketplace.atlassian.com/plugins/info.renjithv.jira.plugins.sysadmin.homedirectorybrowser/server/overview

How to do it...

Perform the following steps to query the JIRA database directly in the JIRA UI:

  1. Navigate to Administration | Add-ons | Db Console.
  2. Select the database table ...

Get JIRA 7 Administration Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.