How to determine if an index volume has some pending additions/deletions/updates

  • Modified Date:
  • Article ID:000064586

Description

There are three tables in the Vault Store database that contain entries for items that have been archived.

  • JournalArchive - This table contains information about items that have been added to the archive
  • JournalDelete - This table contains information about items that have been deleted from the archive
  • JournalUpdate - This table contains information about items that have been updated in the archive

Where an entry in any of these tables has the IndexCommited column set to 0, this means that the related index volume has pending additions, deletions or updates.

For example, to find all of the index volumes that contain pending additions, use the following query:

use EnterpriseVaultDirectory
select VaultEntryId,ArchiveName,FolderName from IndexVolumeView IVV
where IVV.VaultEntryId in (select distinct AP.ArchivePointId from  EVVSVStoreThread_13..ArchivePoint AP
inner join EVVSVStoreThread_13..JournalArchive JA
on AP.ArchivePointIdentity = JA.ArchivePointIdentity
and JA.IndexCommited = 0)


Replace EVVSVStoreThread_13 with the name of the Vault Store database. 
 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)