Where are email logs stored indefinitely in ServiceNow?

[krishnagopal_sn]

I require assistance in identifying the table name within ServiceNow where email-related details, specific to a record, are stored. For instance, when an email is sent from a workspace linked to a particular record, this action is recorded under activities. I understand that email activities are typically tracked in the sys_email table. However, since this table undergoes purging activities, data stored within it may be removed over time. Consequently, if the sys_email table purges data, will the activities section lose track of the emails sent? Upon attempting to delete a record in the sys_email table, I observed that the corresponding activity was also removed from the record. Therefore, my query revolves around how the activities section intends to retain email data indefinitely.

[Mark Manders]

Did you also check the sys_history_line and sys_audit table for this? 

If it's completely gone, it may be a good thing to add the email content to the worknotes/comments of a record, so it will always be there?

[krishnagopal_sn]

Yes, I did consider checking the sys_history_line and sys_audit tables as well. However, upon investigation, I couldn't find any relevant information pertaining to the retention of email content within those tables.

Regarding the suggestion to add email content to the worknotes/comments of a record for permanent retention,

What I feel is that if agents send emails and then manually update worknotes or comments, it could lead to redundant activities. What I need is, the system should provide a seamless way to archive email communication associated with specific records without requiring manual intervention.

[Mark Manders]

Why would an email be send from a record and after that the comments/work_notes be updated as well, if you add the email to the comments already? Doing this will just help out not having to add comments/work notes after sending the email. You want that info in your ticket, so why not do it automatically?

And you said you deleted an email and it was removed from the activity. The system doesn't store email data forever, so you will need to either make sure you have that data in the records themselves, or you go to ServiceNow and ask them to change the current way of handling things. The first solution will be the fastest way of getting this done.