cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
398
Views
0
Helpful
2
Replies

What exactly does the Historical Database Purge purge?

dargueta
Level 1
Level 1

I have ran the purge for data older than 13 months, however when I look at the "AgentStateDetail" table inside the db_cra database in SQL, I see records from 2004. Does this purge not take care of those records? If not, does anyone know how to clean up the database so that the old records inside that table are purged?

2 Replies 2

Not applicable

You can purge the call records manually using SQL Queries from SQL Enterprise Manager. This should be done during a period of no call traffic so if you do need to revert back you will not lose any new call data.

Below is an example for using SQL Queries to delete data:

Database - db_cra

Delete from agentconnectiondetail where startdatetime < 'date time'

Thanks. I thought about doing it this way, but I wasn't sure whether the records were linked to other data in other tables......Thanks for the response!

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: