Exchange Mailbox Archive Information

here is a query for you (been a while since I tested it so give it a whirl): -- This gives the archive name and count of items by retention cat. You can throw in a Where clause and specify a user name if you desire. -- Runs against the VaultStore Database SELECT a.ArchivePointID, ex.MbxDisplayName, s.ArchivePointIdentity, rc.RetentionCategoryName, COUNT(s.RetentionCategoryIdentity) as Count FROM Saveset s Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity Join EnterpriseVaultDirectory.dbo.RetentionCategoryEntry rc on rc.RetentionCategoryIdentity = s.RetentionCategoryIdentity Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID GROUP BY ArchivePointID,s.ArchivePointIdentity, rc.RetentionCategoryName, ex.MbxDisplayName There is a KB for your second question but in my history with EV it is the hardest KB for me to find for some reason. It details a process you should go through with archives where you intend to delete the associated account. From memory it is something like change it to a zero day archiving policy and process now. Disable archiving for the user, remove the account.... something like that. Sorry I did not find it but i gave it a good five minutes of searching and always have a problem finding that specific KB. Hope this helps