Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

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.

 

 

SOLUTION
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.OldestItemDateUTC IS NOT NULL
  AND  IV.YoungestItemDateUTC IS NOT NULL
ORDER BY A.ArchiveName