Purpose

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

Solution

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