Data management in Conversational Interfaces

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • Use data management tools, such as table cleaners, to maintain Conversational Interfaces tables.

    Virtual Agent table cleaning

    Virtual Agent has a data retention policy that automatically deletes records from certain base system tables when they reach a specific age, to prevent tables from growing to an unmanageable size. Some Virtual Agent and related Conversational Interfaces tables are not automatically cleaned. You can activate table cleaning for the following tables.

    Table 1. Conversational Interfaces tables that need cleaning
    Table label Table name Description Default record age (seconds)
    Chat Server Analytics sys_cs_analytics Server records that include sys IDs for messages, threads, conversations, users, and events. 7,776,000
    Conversations sys_cs_conversation Conversation details, including topic definition, device used, and consumer (user).
    Note:
    Table cleaner also automatically deletes the related records for the following:
    • Conversation Messages
    • Conversation Tasks
    • Conversation Members
    • Session bindings
    • Profane message logs if using the Profanity Filter

    5,184,000
    Message Last Reads sys_cs_message_last_read Message IDs of the last messages read by users in chat and messaging channels. 15,552,000
    CI Analytics sys_ci_analytics Conversation details used in Conversational Analytics. If the conversation ID is available, table cleaner removes closed, complete, and faulted conversations from the Conversations [sys_cs_conversation] table. 604,800

    The Auto Flushes [sys_auto_flush] table lists the base system tables and their corresponding record ages. When table cleaning is activated, the Table Cleaner scheduled job triggers the table cleaner to remove the records that meet the default record age. If needed, you can change the record age for a table and specify any conditions to filter the records to be removed. For details, see Activate table cleaning for Virtual Agent tables.

    If a table has related child tables, the table cleaner automatically performs a cascade delete to remove the related child tables. For example, when table cleaning is activated for the Conversation [sys_cs_conversation] table, the table cleaner runs automatically when the table is 60 days (5,184,000 seconds) old. The table cleaner also performs a cascade delete to remove the related child tables. To learn more about table cleaning in the ServiceNow AI Platform, see Table cleaner.