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

Deleting CDR Records for a particular Extension

Hi all,

I am having a CCM4.1 With the CDR enabled.Now ther is an new requirement, that I need delete the CDR details for an particular extension.

Kindly help me out to acheive that.

Thanks in advance,

Kumar

3 REPLIES
New Member

Re: Deleting CDR Records for a particular Extension

Hi,

You need to run a SQL query for this.

=Amit

Re: Deleting CDR Records for a particular Extension

Hi Amit,

You are Right, I tried executing the SQL below in the CDR Database:

Detele from CallDetailRecord where callingPartyNumber = 'xxxx'

Detele from CallDetailRecordDiagnostics where callingPartyNumber = 'xxxx'

After executing this, it shows that the Records has been deleted.But When I Search in the CDR Webpage, it shows the records.

If you have any SQL , let me know amit.

Thanks,

Kumar

New Member

Re: Deleting CDR Records for a particular Extension

107
Views
0
Helpful
3
Replies
CreatePlease to create content