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)
Loading.
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

Hi,


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



--START--

USE CDR

SELECT callingPartyNumber AS CallingNumber, originalCalledPartyNumber AS CalledNumber

FROM CallDetailRecord

WHERE (dateTimeOrigination > 1180310400 AND dateTimeOrigination < 1180396799)

--END--


http://www.onlineconversion.com/unix_time.htm


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?


Thanks!!

Actions

This Discussion