How to determine if an index location is open/closed using the SQL EnterpriseVaultDirectory database.
Article ID: 100039329
Updated On:
Description
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
IMPORTANT: Do not edit this content in Information Manager
Internal Notes
The content of this document is referenced in the Enterprise Vault 10.0 Indexing Key Topics. Do not make changes to this article. If you would like changes to be made to this content, use the Information Manager feedback feature. Alternatively, you can send e-mail to the owner or the Enterprise Vault Knowledge Management team DL-CS-KM.
Issue/Introduction
