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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.