Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

What exactly does the Historical Database Purge purge?

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
Anonymous
N/A

Re: What exactly does the Historical Database Purge purge?

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'

New Member

Re: What exactly does the Historical Database Purge purge?

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!

178
Views
0
Helpful
2
Replies