Running Query on Jira's Data Base

[Lucas Romani de Araujo]

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"

[Ravi Sagar _Sparxsys_ · Accepted solution]

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 solution]

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.

[Mohamed Benziane · Accepted solution]

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