Forum Discussion

Elio_C's avatar
Elio_C
Level 6
11 years ago
Solved

SQL Query to List Index Server and Folder by Archive

Hi,

I'm looking for a SQL query to tell me the Index server and folder location for each archive, something like:

Archive Name     Archive ID     Index Server     Index Folder Path

The detail in the IndexRootPathEntry table is what I need, how does this link to the Archive details?

Any help greatly appreciated.

Thanks

Enterprise Vault
Information Governance
Reporting
Tip-How to
Windows Server (2003-2008)
  • GabeV's avatar
    GabeV
    11 years ago

    Hi,

    You can use the IndexVolumeView view:

    USE EnterpriseVaultDirectory

SELECT * FROM dbo.IndexVolumeView

    I hope this helps.

2 Replies

  • GabeV's avatar
    GabeV
    Level 6
    11 years ago

    Hi,

    You can use the IndexVolumeView view:

    USE EnterpriseVaultDirectory

SELECT * FROM dbo.IndexVolumeView

    I hope this helps.