Showing results for 
Search instead for 
Did you mean: 

Retention categories (retro action)

Level 5

Hi all, I have an environment I've been working with to initiate a change in retention category and kick off storage expiry

The default category was 'keep forever', which I changed to 7 years, sync'd all the mailboxes, updated the indexes and checked the expiry reports and a few mailboxes - most had done what I wanted but some inboxes had emails in them that were contray to this new policy


My question then, if I get a message ID via client diagnostics, is there a query I can run to see what category the message was archived against?


Seeing as I got some to delete and some remain, does anyone have any advice for how I can troubleshoot further?


Level 5

Additional - even if I can't find out the Retention Cat the message archived against, can I identify the date it was archived? There's an outside chance the messages not expiring were archived later than what I'm being told

Level 6
Employee Accredited

Hi Bluesteel,

You can get the details using following steps :

1. Open outlook.

2. Select the archived item. (For you want to see the Retention Category)

3. Then Press "Ctrl" and "Shift" Key and click on any EV toolbar icon. (Store in vault / restore/ search)

4. From "Enterprise Vault Diagnostics" click on "Vault Information".

5. Then click on Send to clipboard and paste into Notpad.

6. Search for word DEFAULTRETENTIONCATEGORYID and notedown the number.

7. From SQL server open SQL mgmt studio.

8. From "EnterpriseVaultDirectory" Database open table "RetentionCategoryEntry" and search for column name "RetentionCategoryID" and match above ID with this one and you will get name of retention Category which assign to that archived email.


Level 6
Employee Accredited

Hello bluesteel,

If you want to get the archive date, then you need to get the transaction ID from the Saveset ID and query the saveset table in the vault store database:

SELECT ArchivedDate FROM Saveset WHERE IdTransaction = 'TransactionID'

** Update **

The transaction ID is in the saveset ID. For instance:

Saveset ID: 201107069961508~201106082150450000~Z~90A732262A7CB691832CBE16CC6B1E91

The Transaction ID is the last section of the Saveset ID but you need to add dashes in this format:

Transaction ID: 90A73226-2A7C-B691-832C-BE16CC6B1E91

I hope this helps

Level 5

Fantastic guys, thanks for your help - I'll give these a whirl