EV Retention Policy

[Greenroomboy]

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

Thanks

Steve

[Wayne_Humphrey]

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.

SELECT 
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'
 
FROM
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS ESE,
EVMailboxVS01..ArchivePoint AS VS1
 
WHERE
EME.DefaultVaultID  = VS1.ArchivePointID AND
EME.MbxArchivingState = 1 AND
EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity

--wayne

[MichelZ]

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 www.evtools.net website.

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

Cheers
Michel