11-05-2008 12:57 PM - edited 03-14-2019 03:11 AM
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?
11-11-2008 07:03 AM
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'
11-11-2008 01:22 PM
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!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide