Delete cdr records for individual extension/device

Unanswered Question
Apr 16th, 2009

Hi,

Could you let me know if its possible to delete all cdr records for an individual extension. We have an ATA device which is filling up the CDR database with spurious calls.

Callmanager version we are running is 4.2(3).

Thanks

Imtiaz

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
david-lima Fri, 04/17/2009 - 05:23

Hi maybe you can use the SQL to run a query that delete a specific record, for example:

On CDR Database

delete from calldetailrecord where callingpartynumber='DN of ATA'.

If is possible, try in a lab enviroment first..

Hope this help

David

iqadeer2e2 Tue, 04/21/2009 - 01:42

Thanks David for coming back to me.

I did manage to delete the calls by going into enterprise manager and selecting rows. the query I ran is as follows:

SELECT *

FROM CallDetailRecord

WHERE (callingPartyNumber = '4156')

Actions

This Discussion