目的

At times we may need to identify the JIRA application build number. This query will return the build number from the database.

ソリューション

Run the following query to the database:

select propertyvalue from propertystring where id = (select id from propertyentry where property_key = 'jira.version.patched');

Use this page to cross reference the Build Number - JIRA Build and Version Numbers Reference