Hello,
the below query will list some basic information about the archives. It is safe to assume if the Newest Archived Item is < 1/1/2013 those archives are for users who left. But, I would also check/verify with HR department.
--
-- Query shows Archive Information of one user, when archivename is filled in
-- Change My User to archivename needed
-- For all archives in VS, comment And A.ArchiveName - 'My User' etc
--
-- Change MyVaultStore to your VaultStore database name
SELECT A.ArchiveName "Archive Name",
AP.CreatedDate "Archive Created",
AP.ModifiedDate "Archived Last Modified",
MIN(S.IdDateTime) "Oldest Sent/Received Item",
MAX(S.IdDateTime) "Newest Sent/Received Item",
MIN(S.ArchivedDate) "Oldest Archived Item",
MAX(S.ArchivedDate) "Newest Archived Item"
FROM EnterpriseVaultDirectory.dbo.Archive A,
EnterpriseVaultDirectory.dbo.Root R,
MyVaultStore.dbo.ArchivePoint AP,
MyVaultStore.dbo.Saveset S
WHERE A.RootIdentity = R.RootIdentity
AND R.VaultEntryId = AP.ArchivePointId
AND AP.ArchivePointIdentity = S.ArchivePointIdentity
AND A.ArchiveName = 'My User'
GROUP BY A.ArchiveName, AP.CreatedDate, AP.ModifiedDate
order by AP.CreatedDate
