How to determine how many index volumes are online/offline using the SQL database
| Article:HOWTO56252 | | | Created: 2011-07-27 | | | Updated: 2011-07-31 | | | Article URL http://www.symantec.com/docs/HOWTO56252 |
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|
|
Article URL http://www.symantec.com/docs/HOWTO56252
Terms of use for this information are found in Legal Notices
Thank you.