In EV 9 how do I count the index volume total using SQL script?

[John_Santana]

Hi All,

Can anyone here please assist me with the SQL Script to count the total number of EV Index Volume ?

Because I need to estimate the total amount of time to perform Upgrade index metadata and schema version.

The index upgrade may take some time. For example, an Enterprise Vault server
with the minimum recommended specification may take 40 minutes or longer to
process 5,000 index volumes.

[AndrewB · Accepted solution]

give this a try:

Use EnterpriseVaultDirectory

select count (*) from IndexVolume

[John_Santana]

Thanks Andrew,

Cool, the script works out just right for me :)

USE enterprisevaultdirectory 

SELECT Count (*) 
FROM   indexvolume