How to find the Jira Server or Data Center Build Number from the database

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

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:

1 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 Server and Data Center build and version numbers reference

Updated on April 8, 2025

Still need help?

The Atlassian Community is here for you.