EV10 - SQL to find archives that have 64 bit index
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?