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.
Run the following SQL Query to identify all of the currently open index locations:
WHERE IndexRootPathStatus = 0