Video Screencast Help

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

Created: 21 Jul 2014 • Updated: 21 Jul 2014 | 2 comments
This issue has been solved. See solution.

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.

Operating Systems:

Comments 2 CommentsJump to latest comment

AndrewB's picture

give this a try:

Use EnterpriseVaultDirectory

select count (*) from IndexVolume

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner |

John Santana's picture

Thanks Andrew,

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

USE enterprisevaultdirectory 

SELECT Count (*) 

FROM   indexvolume

Kind regards,

John Santana
IT Professional


Please be nice to me as I'm newbie in this forum.