Dialed number on CDR

[eduestme2]

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?

[heathrw]

What version of call manager?

[eduestme2]

Version 4.2(3)sr2b

[heathrw]

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]

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!!