01-07-2015 03:35 AM
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
Solved! Go to Solution.
01-07-2015 07:03 AM
Hi,
You can use the IndexVolumeView view:
USE EnterpriseVaultDirectory SELECT * FROM dbo.IndexVolumeView
I hope this helps.
01-07-2015 07:03 AM
Hi,
You can use the IndexVolumeView view:
USE EnterpriseVaultDirectory SELECT * FROM dbo.IndexVolumeView
I hope this helps.
01-07-2015 07:07 AM
Perfect, thanks very much