04-16-2009 11:33 PM - edited 03-15-2019 05:30 PM
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
04-17-2009 05:23 AM
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
04-21-2009 01:42 AM
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')
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