Version 4.2(3)sr2b

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

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