How to find Enterprise Vault version information

Problem

Below is a listing of the versions for Enterprise Vault (EV). After verification of the binaries on the EV server, it is imperative that the schema version of the Vault Directory and Vault Store databases both match appropriately. Any differences will result in loss of functionality within the product.

Cause

It is crucial that component versions are at the same EV product/schema version across all EV/SQL servers. A mismatch could have occurred because of a partial or failed upgrade. See the Installation Guide or Upgrade Documents to assist with confirming a successful upgrade or new installation.

Solution

The EV Directory Database SchemaVersion can be found by running the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion AS 'EVDirectory db Schema Version'
FROM DirectoryEntry;
 

The EV VaultStore Database SchemaVersion can be found by running the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion AS 'EV Vault Store db Schema Version'
FROM VaultStoreEntry;
 

The EV Fingerprint Database SchemaVersion can be found by running the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion AS 'EV Fingerprint db Schema Version'
FROM FingerprintCatalogueDatabase;
 

The version returned must match the below SchemaVersion found in the ConfigSettings table of the Vault Store Group (VSG) database.  

USE Vault_Store_Group_Database_Name -- Replace with correct VSG DB name
EXEC [dbo].[GetSchemaVersion]

The EV FSAReportingDatabase SchemaVersion can be found by running the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion AS 'EV FSA Reporting db Schema Version'
FROM FSAReportingDatabase;
 

The EV Monitoring Database SchemaVersion can be found by running the following SQL query:

USE EnterpriseVaultDirectory
SELECT SchemaVersion AS 'EV Monitoring db Schema Version'
FROM MonitoringSettings;

The EV Audit Database SchemaVersion can be found by running the following SQL query:

USE EnterpriseVaultAudit
SELECT SchemaVersion AS 'EV Audit db Schema Version'
FROM Audit;

The EV Binaries Version can be found in the registry:
 

[HKEY_LOCAL_MACHINE\SOFTWARE\KVS\Enterprise Vault\Install] 
"Version"

On a 64bit OS, everything is under a WOW6432Node key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Install]
"Version"  

Note: Not all of the below-listed versions are supported.  For End of Life and End of Support Life information, please refer to the Product life cycle information page.

Enterprise Vault Versions Information:

EV Product Version

Beginning with EV 10.0.4, cumulative hot fix (CHF) installations are implemented using a CHF Installer in the form of a "setup.exe" file.  Each CHF will have its own version information and may or may not update the schema versions of the EnterpriseVaultDirectory, Vault Store and / or Fingerprint databases.  The following table presents the versions of these entities after the CHF installation.

Note: The CHF Version can be found in the registry of the EV server, replacing EV# with the EV version and CHF# with the CHF version.

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Install\Hotfixes\EV#\CHF#\]Version

For example: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Install\Hotfixes\12.1.0\12.1.1

(1) The 11.0.1CHF4 release was superseded by the 11.0.1CHF4R1 release, with the 11.0.1CHF4R1 release now referenced as 11.0.1CHF4.

Note:  This is only applicable to the EV Server and not applicable for any Accelerator or associated EV products.  For version information for Compliance Accelerator or Discovery Accelerator, see 100010618 in the Related Documents section below.