Overview:
A SQL query can be run in the event there is a need to get a list of the Index locations for all enabled users in EV.
Solution:
1. SQL 2000, open SQL Query Analyzer or SQL 2005, SQL Server Management Studio, click New Query button on the toolbar
2. On the toolbar, select EnterpriseVaultDirectory database
3. Execute the following query for the results:
SELECT IndexVolume.FolderName, IndexRootPathEntry.IndexRootPath, ExchangeMailboxEntry.MbxDisplayName
FROM IndexVolume INNER JOIN
IndexRootPathEntry ON IndexVolume.IndexRootPathEntryId = IndexRootPathEntry.IndexRootPathEntryId INNER JOIN
Root ON IndexVolume.RootIdentity = Root.RootIdentity INNER JOIN
ExchangeMailboxEntry ON Root.VaultEntryId = ExchangeMailboxEntry.DefaultVaultId
