Video Screencast Help

EV 9.0.2 email archiving

Created: 18 Dec 2012 • Updated: 21 Dec 2012 | 3 comments
This issue has been solved. See solution.

We are using EV 9.0.2 to archive Exchange 2010 email.  We have it setup to leave a shortcut in the mailbox for Vaulted items.  Our end users are using Outlook 2007 SP3.  My question is this: Is there an easy way to tell what the newest or oldest archived item is per mailbox?  Is there a script that I can run or a canned report to get this information?

Thanks for the help.

Comments 3 CommentsJump to latest comment

Rob.Wilcox's picture

For an individual archive, you can get this from the archive properties.  From the archive properties click on 'Advanced', and you'll see the youngest and oldest item.  Note that I think it has been discussed here before where the oldest item can be 'odd', ie vvvvvery old, because of attachments to messages.

For many archives, like a report, you might like to consider that the data is in the IndexVolume table in the Directory database.

JesusWept3's picture

Usually the Oldest Item being way out of a date range is typically always spam, so you will sometimes see email from 1683 or something, you get that email and its spam for printer ink or some such stuff

JesusWept3's picture

Yeah the query would be

USE EnterpriseVaultDirectory
SELECT A.ArchiveName,
       CONVERT(varchar, IV.OldestItemDateUTC, 113) "Oldest Item",
       CONVERT(varchar, IV.YoungestItemDateUTC, 113) "Newest Item"
FROM   Archive A, 
       IndexVolume IV
WHERE  IV.RootIdentity = A.RootIdentity
  AND  IV.YoungestItemDateUTC IS NOT NULL
ORDER BY A.ArchiveName