Book Image

JIRA 7 Administration Cookbook - Second Edition

By : Patrick Li
Book Image

JIRA 7 Administration Cookbook - Second Edition

By: Patrick Li

Overview of this book

JIRA 7 Administration Cookbook, Second Edition covers all the new major features that provide better prioritizing capabilities, enhanced visibility, and the ability to customize JIRA application to meet your needs. We start by upgrading your existing JIRA instance and working through tasks you can perform at the server level to better maintain it. We then delve deep into adapting JIRA to your organization's needs, starting with the visual elements of setting up custom forms to capturing important data with custom fields and screens, and moving on to ensuring data integrity through defining field behaviors. You'll gain insights into JIRA's e-mail capabilities, including managing outgoing e-mail rules and processing incoming e-mails for automated issue creation. The book contains tips and tricks that will make things easier for you as administrators, such as running scripts to automate tasks, getting easy access to logs, and working with tools to troubleshoot problems. The book concludes with a chapter on JIRA Service Desk, which will enable you to set up and customize your own support portal, work with internal teams to solve problems, and achieve optimized services with SLA.
Table of Contents (15 chapters)
JIRA 7 Administration Cookbook - Second Edition
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface

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 to query from.

  3. Select the columns to include as part of the query, or leave it blank for all the columns.

  4. Optionally, you can construct your own queries in the Enter SQL text field.

  5. Click on the Execute button to run the SQL query, as shown in the...