Data Migration for sys_email table for HR cases

[Simanta27]

Hi Everyone,  I need to migrate the records of the sys_email table from one instance to another, but for sys_email table there is a data rotation that's active which purges the email records after a certain interval, does anyone know about any other table that stores the emails for an indefinite period?

Thanks in advance!

[Mark Manders]

If you're lucky: ar_sys_email

Check this link as well. If they aren't there, I am afraid you won't be able to get them back. I do think you need to think if it is really necessary to move this kind of old data. Anything that was ever processed, is still in the records it created/updated.

[Siddhesh Gawade]

Hello @Simanta27 ,

You can use the "ar_sys_email" table. this table contains records from the Email [sys_email] table when they exceed the archive rule time limit. So you need to query the required records and need to restore those records and then you can use them again from sys_email table for data migration.

Check some support/community article for bulk restoration of record:

Unable to bulk re-archive restored records 

We need to be able to mass restore archived records...is that possible? If so, how? 

Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.

Regards,

Siddhesh

[Simanta27]

"ar_sys_email" - No table as such present in the instance. 🙂

Can you please provide a screenshot for the same? Thank you.

[Siddhesh Gawade]

@Simanta27 ,

Just search "archive" in your navigator, you should be able to see "archive email" option. Still not, then I am suspecting the Data archiving  "com.glide.auxdb" plugin is not installed in your instance. 

So now unfortunately, you cannot use this way, you need to check another way solving this.

You may use sys_email_log table, which may different rentetion policies than sys_email table  and if you are lucky you will find the required records for migration.

Regards,

Siddhesh