Forum Discussion

Greenroomboy's avatar
Greenroomboy
Level 4
16 years ago

EV Retention Policy

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
Enterprise Vault
Information Governance
  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    Level 6
    16 years ago
    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's avatar
    MichelZ
    Level 6
    16 years ago
    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