How to determine if an index location is open/closed using the SQL EnterpriseVaultDirectory database.

Description

The EnterpriseVaultDirectory database IndexRootPathEntry table and view_IndexRootPath view contains information about each index location within the Directory. This includes a column named IndexRootPathStatus. The IndexRootPathStatus shows the current state of each Index Volume associated within the Directory. Possible values of this entry are:

  • 0 – Indicates that the location is open. Indexing can add data to this location.
  • 1 – Indicates that the location is closed. Indexing cannot add data to this location. If there are new items for existing indexes, Indexing uses a different location.


Example: 
Run the following SQL Query to identify all of the currently open index locations:

USE EnterpriseVaultDirectory
SELECT *
FROM View_IndexRootPath
WHERE IndexRootPathStatus = 0

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)