Running Query on Jira's Data Base

Question

Hi,

I need to run the below query on my Jira's Data Base but I don't know how to do it and how I can see the name of the database that Jira uses. Can you help me to find these informations and to know how to run a query on Jira Database ?

"select * from AO_1B155C_AIO_TENANT"

Mohamed Benziane · Accepted Answer

Hi,

Welcome to the community

You will need an access to the database (password, username, hostname...), and a tool like Pgadmin or Mysql depending what database Jira is using. Ask people who set the "backend" for Jira.

If you go to this page you will get information about database

https://<YOURJIRANAME>/secure/admin/ViewSystemInfo.jspa

If you have scriptrunner installed in your instance you can run your query in Jira UI.

https://scriptrunner.adaptavist.com/5.6.8/jira/resources.html#_local_database_connection

Hope this help

Ravi Sagar _Sparxsys_ · Accepted Answer

Hi @Lucas Romani de Araujo

You can use native database client utilities for MySQL, Postgres or whatever database you are using.

Also take a look at the database schema.

You can also do that using ScriptRunner by either writing a Groovy script or using the Resources feature.

I hope it helps.

Ravi

nos hyp · Accepted Answer

so nice

You can use native database client utilities for MySQL, Postgres or whatever database you are using.

Also take a look at the database schema.