Forum Discussion

Sani_B's avatar
Sani_B
Level 6
13 years ago

Help! How do I locate the fingerprint database in process of moving the Enterprise Vault (EV) SQL databases from one SQL server to another.

Hi, I'm going to move the Enterprise Vault (EV) SQL databases from one SQL server to another following this article: http://www.symantec.com/docs/TECH35744  (yes I have SQL specialist doing the h...
Configuring
Enterprise Vault
Information Governance
Installing
Training
Upgrade
  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    13 years ago

     

    You can use the following SQL query, to get a list of all Fingerprint Databases and there locations

    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
Sani_B's avatar
Sani_B
Level 6
13 years ago

Thank you Wayne! =) Found the data :)

Sani B.