How to archive records from Conversation Task and Conversation Message tables?

[Saraswathi Devi]

Hi Community,

We are working on data archiving in ServiceNow and have a question regarding archiving Conversation Task and Conversation Message records.

Currently, we have archive rules in place for Interaction and Interaction Log tables based on conditions like:

• state = completed
• Closed before 5 years

However, we are unable to find any direct reference or relationship between the Conversation Task / Conversation Message tables with Interaction Log table that would allow us to use Archive Related Records.

Given this limitation:

• What is the recommended or supported approach to archive records from Conversation Task and Conversation Message tables?
• Are there any best practices or considerations we should be aware of when archiving these conversation-related tables?

[Tanushree Maiti]

1. The preferred way to archive records from the Conversation Task (conversation_task) and Conversation Message (conversation_message) tables in ServiceNow is by using the built-in System Archiving feature.

Refer: Optimizing ServiceNow Data Lifecycle: Archiving, Rotation, and Cleanup Strategies

             Data Archiving Walkthrough

2) Refer : ServiceNow Data Archiving: Common Fears, Concerns and How to Resolve Them 

[SaraswathiD8216 · Accepted solution]

We are able to see the tables that start with sys_ once they are added to the glide.ui.permitted_tables system property.