Screencasts - Hilfsvideos

EV 9.0.2 email archiving

Created: 18 Dez. 2012 • Aktualisiert: 21 Dez. 2012 | 3 Kommentare
Dieses Problem wurde gelöst. Siehe Lösung.

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.

Kommentare KommentareZum neuesten Kommentar

das Bild der Rob.Wilcoxs

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.

das Bild der JesusWept3s

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

das Bild der JesusWept3s

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