How to determine if an index location is open/closed using the SQL EnterpriseVaultDirectory database.
|Article:HOWTO56254|||||Created: 2011-07-27|||||Updated: 2014-12-10|||||Article URL http://www.symantec.com/docs/HOWTO56254|
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
Article URL http://www.symantec.com/docs/HOWTO56254