How to determine how many index volumes are online/offline using the SQL database

Article: 100039327
Last Published: 2021-10-04
Ratings: 1 0
Product(s): Enterprise Vault

Description

The Directory database IndexVolume table and IndexVolumeView view contain index volume information. This includes a column named Offline. If the Offline value is:

0 – The index volume is online
1 – The index volume is offline


To find only online index volumes, use the query:

use EnterpriseVaultDirectory
Select *
from IndexVolumeView
where Offline = 0

Was this content helpful?