Dialed number on CDR

Unanswered Question
Nov 5th, 2007
User Badges:

How to dump dialed number on CDR Table? I see that to dump only the result from route pattern. Ex: 8.55121200 (predot) the result is 55121200 wich is on CDR table. Anyone help me?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
heathrw Mon, 11/05/2007 - 14:21
User Badges:
  • Bronze, 100 points or more

What version of call manager?

heathrw Tue, 11/06/2007 - 12:57
User Badges:
  • Bronze, 100 points or more


Terminal Services into your Call Manager start SQL Query Analyzer which should start a blank query copy/paste between the start finish. Use the web page to replace the two strings of numbers (epoch time) start date/time finish date/time. Check if this matches up with what you are after. Use the Play button to execute query.

Hope this helps, let me know how it goes



SELECT callingPartyNumber AS CallingNumber, originalCalledPartyNumber AS CalledNumber

FROM CallDetailRecord

WHERE (dateTimeOrigination > 1180310400 AND dateTimeOrigination < 1180396799)



eduestme2 Wed, 11/07/2007 - 05:36
User Badges:

Thanks for the query! The question is: How to save on cdr the real dialed number? On CDR is save the result from route pattern.

Anyone help me?



This Discussion