Video Screencast Help

SQL query for Enterprise Vault 8

Created: 26 Feb 2010 • Updated: 21 May 2010 | 2 comments
This issue has been solved. See solution.

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! 

Comments 2 CommentsJump to latest comment

JesusWept3's picture

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

SOLUTION