RichardF14
14 years agoLevel 3
Storage Expiry Report
Hello,
Does someone know how to generate a report that shows the items that will be removed from the Vault stores when the next storage expiry job runs.
(to generate a report 1 week before the expiry job runs)
Richard.
Take a look at the link that i attached and try that SQL Query, it will give you more accurate counts based on the fact that it looks as to whether users have expiry enabled for their archive and whether the item is on hold and such.
As for your query though, you really need to link ArchivePoint to the Root table as opposed to ExchangeMailboxEntry as you can have archives that don't exist in the EME table (maybe because they have been deleted etc)