How to determine how many 32bit or 64bit index volumes there are in the directory

Article:HOWTO56251  |  Created: 2011-07-27  |  Updated: 2014-12-10  |  Article URL
Article Type
How To

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

0 – The entry is for a 32bit index volume
1 – The entry is for a 64bit index volume

To find only 64bit index volumes, use the query:

use EnterpriseVaultDirectory
Select *
from IndexVolumeView
where IndexVolumeType = 1

Article URL

Terms of use for this information are found in Legal Notices