Question around SQL query
I have a customer that has been running EV since 2005 and during that time some Journal Data was stamped with the wrong Retention Category. The Journal RC is 7 years and the Mailbox RC is 3 years. This incorrect marking of Journal data occurred in 2006 or 2007. The customer uses a Centera for storage of items running in Basic mode with Collections enabled. The customer has multiple Journal VS but only one Mailbox VS
Anyway the result is now when you implement Storage Expiry some Journal Data gets removed before it is suppose to. I am trying to think of ways to implement Storage Expiry without the customer losing Journal Data
I found a query that will show me how much data in each VS is marked by what RC, see the link below
But is there a way to see when this data was stored? From there we can say that means this data will be removed in Month xxx year xxx so we can at least position how much Journal data will be deleted before its time?
Also is there an alternative way to delete this data from EV without Journal data being removed. I was thinking about changing the Retention Period but I am not sure how this would work in this scenario or even be effective