EV10 - SQL to find archives that have 64 bit index

[GertjanA]

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

[plaudone]

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 · Accepted solution]

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 

[GertjanA]

Excellent, thanks! Just what I was looking for.