SQL query for Enterprise Vault 8

[LegalITTech]

Are there any SQL gurus out there who can provide a SQL query to return the following: name of vault or user; current index; total number of items; size of vault

My intention is to use this information to move active mailboxes which contribute a large number of new items to a closed Index.

Thanks! 

[JesusWept3 · Accepted solution]

SELECT A.ArchiveName, (IRP.IndexRootPath + '\'+ IV.FolderName) AS Folder, IV.FirstItemSequenceNumber AS FirstISN, IV.HighestItemSequenceNumber AS LastISN, IV.IndexedItems, IV.Rebuilding, IV.Failed, IV.FailedItems
FROM IndexRootPathEntry IRP,
       IndexVolume IV,
       Archive A,
       Root R
WHERE A.RootIdentity = R.Rootidentity
  AND R.RootIdentity = IV.RootIdentity
  AND IV.IndexRootPathEntryId = IRP.IndexRootPathEntryId

You can use that as a starting point if you want

[LegalITTech]

 Thanks!