Video Screencast Help

Retention categories (retro action)

Created: 18 Feb 2014 | 4 comments

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?

Operating Systems:

Comments 4 CommentsJump to latest comment

EVSpinner's picture

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

EV_Ajay's picture

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.



GabeV's picture

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

“Success is not final, failure is not fatal: it is the courage to continue that counts.”–Winston Churchill

EVSpinner's picture

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