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

book

Article ID: 100039327

calendar_today

Updated On:

Description

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

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

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