Video Screencast Help

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: