Is there a way to purge chat data from the database?

Environment:

Chat Purge Settings, Chat Data
B2C Service Chat, Oracle B2C Service

Issue:

I am not able to pull data that is older than 6 months when using chat reports.

Resolution:

The agedatabase utility includes the ability to purge chat data.  Chat data can accumulate very quickly, and can now be purged the same way incidents can be.

There are several configuration settings to purge chat data. 

Path to setting(s): Select Configuration from the navigation area > Site Configuration > Configuration Settings > and search by Key.

• CHATS_PURGE_DAYS – Replaced with the data lifecycle policy ‘Purge Chats’ under the Chat object.
   
• CHAT_AGENT_SESSIONS_PURGE_DAYS – Replaced with the data lifecycle policy ‘Purge Chat Agent Sessions’ under the Chat Agent Sessions object.
   
• CHAT_AGENT_EVENTS_PURGE_DAYS – Replaced with the data lifecycle policy ‘Purge Chat Agent Events’ under the Chat Agent Events object.
   
• CHAT_EVENTS_PURGE_DAYS – Replaced with the data lifecycle policy ‘Purge Chat Events’ under the Chat Events object.
   
• CHAT_STATS_MIN_INT_PURGE_DAYS - Specifies the age in days after which the finest-grained statistics records will be purged by the agedatabase utility. This setting affects "chat_agent_stats" and "chat_queue_stats" for the smallest window. Note: For sites with multiple interfaces, statistics will be removed from all interfaces based on the smallest non-zero value for this setting among the interfaces. For this reason it is suggested that all interfaces share the same value for this setting.
   
• CHAT_STATS_HOUR_PURGE_DAYS - Specifies the age in days of hour stats records that will be purged by the agedatabase utility. This setting affects "chat_agent_stats" and "chat_queue_stats" for the hourly window. Default is 30 and maximum is 80.
   
• CHAT_STATS_DAY_PURGE_DAYS - Specifies the age in days of day stats records that will be purged by the agedatabase utility. This setting affects "chat_agent_stats" and "chat_queue_stats" for the daily window. Default is 180.

Note: Chat Purge configurations should be set to non-zero setting

The configuration settings replaced by the data lifecycle policy are no longer accessible via the Configuration Settings menu, starting with the 23C production version. See also Answer 12622: Data lifecycle policies for purging chat records.