Is there a way to find out jira version directly from the database?

[Rahul Aich [Nagra]]

Is there a way to find out jira version directly from the database?

Rahul

[petry]

Yes:
select * from propertystring where id = (select id from propertyentry where property_key = 'jira.version'); 

[Nic Brough -Adaptavist-]

Actually, no.  It's not stored as a direct number!

You might be able to work it out from the data in the "upgradehistory" table (if a system has ever been upgraded) but the database doesn't actually hold the installation version anywhere.

[Naga Purna Chander Inguva]

Hi Rahul,

Try this SQL query and let me know if it helps

select TARGETVERSION from upgradeversionhistory ORDER BY TIMEPERFORMED DESC

Regards

Chander Inguva