Find when the archives are created

Below query will will list result of date when the archive accounts are created for all users who belongs to a particular store. Rename ‘VaultStore’ to your Vault store database name before running the query.

SELECT A.ArchiveName, AP.CreatedDate
FROM   EnterpriseVaultDirectory.dbo.Archive A,
       EnterpriseVaultDirectory.dbo.Root R, 
       VaultStore.dbo.ArchivePoint AP
WHERE  A.RootIdentity = R.RootIdentity
  AND  R.VaultEntryId = AP.ArchivePointId
ORDER BY A.ArchiveName