How to Identify the Name and Location of the Fingerprint Database
To determine the name and location of the Fingerprint Database in an Enterprise Vault environment, you can run the following SQL script within SQL Server Management Studio.
Make sure to select the EnterpriseVaultDirectory database before executing the query.
SQL Script
USE EnterpriseVaultDirectory
SELECT
FCI.DisplayName AS 'Vault Store',
FCD.SQLServer AS 'SQL Server',
FCD.DatabaseName AS 'Database'
FROM
dbo.FingerprintCatalogueInstance AS FCI,
dbo.FingerprintCatalogueDatabase AS FCD
WHERE
FCI.FPCIIdentity = FCD.FPCIIdentity
Expected Output
The query will return a list with the following details:
- Vault Store: name of the associated Vault Store
- SQL Server: name of the SQL Server hosting the database
- Database: name of the fingerprint database
This information is useful for maintenance, backup, or migration operations involving the Fingerprint Database.
