In which db table Jira holds JIRA Base URL confluguration?

[Matt]

In which db table Jira holds JIRA Base URL confluguration?

[Ahmad Faisal · Accepted solution]

Good morning Astro,

The Base URL configuration is stored in the propertystring table. To query out the Base URL, then we can combine the propertyentry and propertystring table, as follows:

select * from propertystring where id in (select id from propertyentry where property_key like '%baseurl%');

I hope that this will help!