Important Update: Cohesity Products Knowledge Base Articles


All Cohesity Knowledge Base Articles are now managed via the Cohesity Support Portal: https://support.cohesity.com/. The Knowledge Base articles available here will not reflect the latest information or may no longer be accessible.

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

Article: 100039327
Last Published: 2021-10-04
Ratings: 0 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?