Does anyone know if the version of Confluence is stored in the Confluence database?

[Fringe Technology]

MS SQL Server 2012

We cannot look in the Confluence file system for the version, we only have a database. 

Table.column or a SQL query would be very much appreciated !!!!

[Steven F Behnke · Accepted solution]

Documentation seems to point to a table that holds the version: confversion

The SVG's listed on this page contain the table names and column names if you'd wish. https://confluence.atlassian.com/doc/confluence-data-model-127369837.html

On my instance (running 6.6.3), the following query --

SELECT TOP 1 BUILDNUMBER 
 FROM CONFVERSION 
 ORDER BY INSTALLDATE DESC;

Returns the following result --

BUILDNUMBER
7502

You can correspond the Build Numbers against the resource here - https://developer.atlassian.com/server/confluence/confluence-build-information/

You'll find that numerous versions are shipped with the same build id. Not sure what to make of that. Depending on what you're trying to do with this information, more granular information may be required. 

[Minh Tran]

Since confluence 5.10.0, the build number will be similar across confluence versions if there is not new upgrade task

The new marketplace build number is introduced to identify between versions for Atlassian marketplace. You can see that column from https://developer.atlassian.com/server/confluence/confluence-build-information/

However, that value is not stored inside a database. What you are only able to find is the build number that @Steven F Behnke mentioned.

You can only find the Confluence version via REST api:

➜ curl https://xyz.com/rest/prototype/latest/buildInfo
{"versionNumber":"6.9.0-m52","buildDate":1522627200000,"buildTimestamp":"2018-04-02T23:56:24.435+0000","buildNumber":"7701","bambooBuildNumber":"259","revisionNumber":"9517ffcdeb32209bfdcc87694efbb0cd82036664"}

[Anuj Sharma]

Hi All, 

I just checked on this and we can get the version information from DB. Just wrote a KB which you can check

https://confluence.atlassian.com/confkb/how-to-fetch-confluence-version-from-database-1101932196.html.

Thanks