How to find the Index location for enabled users Enterprise Vault (EV)
Article ID: 100031274
Updated On:
Resolution
To get a list of the Index locations for all enabled users in EV:
1. In SQL 2005 and 2008, open 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:
Example Display results:
1. In SQL 2005 and 2008, open 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.DefaultVaultIdExample Display results:
Issue/Introduction
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.
Was this article helpful?
Yes
No
Powered by
