cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions
Accepted Solution!

Hi, You can use the

Hi,

You can use the IndexVolumeView view:

USE EnterpriseVaultDirectory

SELECT * FROM dbo.IndexVolumeView

I hope this helps.

View solution in original post

2 Replies
Accepted Solution!

Hi, You can use the

Hi,

You can use the IndexVolumeView view:

USE EnterpriseVaultDirectory

SELECT * FROM dbo.IndexVolumeView

I hope this helps.

View solution in original post

Perfect, thanks very much

Perfect, thanks very much