Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

EV10 - SQL to find archives that have 64 bit index

Created: 06 Dec 2013 • Updated: 06 Dec 2013 | 3 comments
GertjanA's picture
This issue has been solved. See solution.

Hello all,

Is it possible to use a SQL query to see which archive has only a single 64-bit index. (i.e. fully converted)?

I've found that due to the massive size of the archives here, upgrading all indexes in 1 go is choking my EV-servers. I would like to run a query that gives me ArchiveName, Number of items in Index, where the index is not yet converted to 64 bit.

Is that possible?

thanks

Gertjan

Operating Systems:

Comments 3 CommentsJump to latest comment

plaudone's picture

Hi,

This should do it. 

USE EnterpriseVaultDirectory
Select AR.ArchiveName, IV.RootIdentity, IV.IndexedItems, IV.IndexVolumeType from IndexVolume IV
Join Archive AR on IV.RootIdentity = AR.RootIdentity
Where IV.IndexVolumeType = 0 

plaudone's picture

Sorry...that will show you all Archives that are not yet converted to 64-bit.  

The following will list archives with 64-bit indexes.  You can tell by the FolderName and how it differs from the 32-bit format.  

 

USE EnterpriseVaultDirectory
Select AR.ArchiveName, IV.RootIdentity, IV.IndexedItems, IV.FolderName, IV.IndexVolumeType from IndexVolume IV
Join Archive AR on IV.RootIdentity = AR.RootIdentity
Where IV.IndexVolumeType = 1 

SOLUTION
GertjanA's picture

Excellent, thanks! Just what I was looking for.

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS
Company: www.t2.nl

www.quadrotech-it.com

www.symantec.com/vision