Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

EV Tip: How to find the Index location for enabled users

Created: 08 May 2008 • Updated: 02 Mar 2009
bbukowczyk's picture

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

Discussion Filed Under: