cancel
Showing results for 
Search instead for 
Did you mean: 

Are you missing archives?

Jeff_Shotton
Level 6
Partner Accredited Certified

This is just a little something I noticed on a customer engagement recently when doing a healthcheck.
Due to recent schema changes within Enterprise Vault 10, archives now have two locations where the archive type is defined. Historically there has (on occasion) been reason to change the archive type. I know of tools that also do this also. Most likely if a migration or an export has been performed.

However, if, for whatever reason, the  tool or the script only changes one of the two entries (i.e so the archive types are mis-aligned) then the archives will no longer show under either type in the vault admin console.

In order to determine  if this is something that affects you, run the following SQL script. It will only work against later versions of Enterprise Vault 10 (10.0.3+ I believe)  If any rows return, you have a mismatch and therefore archives which are 'missing' from the vault admin console.

use EnterpriseVaultDirectory
select A.ArchiveName, AT.Name as 'Designation 1', AT2.Name as 'Designation 2' from Archive A
inner join [Root] R on R.RootIdentity = A.RootIdentity
inner join ArchiveType AT on A.ArchiveTypeIdentity = AT.ArchiveTypeIdentity
inner join ArchiveType AT2 on R.[Type] = AT2.[Type]
where AT.ArchiveTypeIdentity != AT2.ArchiveTypeIdentity

Obviously if it IS broken you then need to determine what or who it was that did this, and get it rectified!

Jeff