Showing results for 
Search instead for 
Did you mean: 

EV Retention Policy

Level 4
Hi All,

Slightly off the above topic but here's my scenario.

I need to find a clever way to delete users EV archives 180 days after they have left the company.

anyone got any ideas on the best way to acheive this?

Our compliance department have now stated that we should keep Exchange mailbox and EV archive for 180 days after a user has left and then both sets of data should be purged.  If we go over that 180 day period then we are breaking the law.

In order to save the space on my exchange databases i use a termination policy that archives all mailbox data allowing me to purge the mailbox but at present i'm deleting the EV Vault manually.

any help greatly appreciated and if you need more info give me a shout.

Exchange 2007 SP2
EV for Exchange V2007 SP4



Level 6
Partner Accredited Certified
Hi Greenroomboy,

Here is a SQL script for you.... check out the ModifiedDate wich will display as Archive Updated, you can mod the script to look for anything older than T-180.
MbxDisplayName AS 'Mailbox',
ExchangeComputer AS 'Exchange Server',
MbxItemCount AS '#Items (Mailbox)',
VS1.ArchivedItems AS '#Items (Archive)',
MbxSize/1024 AS 'Mbx Size (MB)',
VS1.ArchivedItemsSize/1024 AS  'Archive Size(MB)',
(mbxsize+VS1.ArchivedItemsSize)/1024 AS 'Total Size(MB)',
VS1.CreatedDate AS 'Archive Created',
VS1.ModifiedDate AS 'Archive Updated', 
MbxExchangeState AS 'Exchange State'
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS ESE,
EVMailboxVS01..ArchivePoint AS VS1
EME.DefaultVaultID  = VS1.ArchivePointID AND
EME.MbxArchivingState = 1 AND
EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity


Level 6
Partner Accredited Certified
Hi there

I know that we are working on a Tool which deals with Automatic Archive deletes on certain rules.
Please contact us trough our website.

For exchange it's probably very easy, you can set it to keep the mailbox for 180 days after delete.


cloudficient - EV Migration, creators of EVComplete.