What exactly does the Historical Database Purge purge?

Unanswered Question
Nov 5th, 2008

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?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Anonymous (not verified) Tue, 11/11/2008 - 07:03

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'

dargueta Tue, 11/11/2008 - 13:22

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!

Actions

This Discussion