Forum Discussion

Bruce_Crankshaw's avatar
Bruce_Crankshaw
Level 6
15 years ago

How do you get Uncategorized Email

Hi All
Okay I ran some SQL queries to look at what data has been categorized with what Retention Categories
Across the various Vault Stores the customer has about 300 million items and out of those about 50 million according to SQL ,which I trust , are stamped with the Uncategorized Retention Category
How do items get stamped with this,,,from the VAC I see that you can assign this to Journal Targets and a Provisioning group so I have to assume that is how this was done ?Or will EV use this Retention Category when another situation presents itself ?
Enterprise Vault
Information Governance
  • JesusWept3's avatar
    JesusWept3
    15 years ago

    some people hack retentions out of the database, other times i've seen this is when you have a restored piece of email from a test system that had a retention category and when it archives in a new system that retention category is read, unrecognised and shoved in an uncategorised field

  • Wayne_Humphrey's avatar
    Wayne_Humphrey
    Level 6
    15 years ago
    Bruce muh boy,

    If you delete the retention category it will get an "uncategorized" retention category.  What I would do if I was you is simply rename the retention category and give it the new retention period.

    Or if you have only ever used one retention category then a much easier method is to use SQL to simply populate the whole saveset table with the same retention category.
  • Bruce_Crankshaw's avatar
    Bruce_Crankshaw
    Level 6
    15 years ago
    Hi Waynie :)
    Vegas awaits us :)

    Thanks for the response ,a couple of points
    This customer has several Retention Category and is on EV 8.0 sp3 ...as far as I remember you can't delete Retention Categories from the VAC ?
    They use to be on 7.5 sp 4....could you delete RC in that version ? If so then  that would explain why I have some data as Uncategorized
  • JesusWept3's avatar
    JesusWept3
    Level 6
    15 years ago

    some people hack retentions out of the database, other times i've seen this is when you have a restored piece of email from a test system that had a retention category and when it archives in a new system that retention category is read, unrecognised and shoved in an uncategorised field