SQL Query to List Index Server and Folder by Archive

[Elio_C]

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

[GabeV · Accepted solution]

Hi,

You can use the IndexVolumeView view:

USE EnterpriseVaultDirectory

SELECT * FROM dbo.IndexVolumeView

I hope this helps.

[Elio_C]

Perfect, thanks very much