Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Dialed number on CDR

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?

4 REPLIES
Bronze

Re: Dialed number on CDR

What version of call manager?

Community Member

Re: Dialed number on CDR

Version 4.2(3)sr2b

Bronze

Re: Dialed number on CDR

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

Community Member

Re: Dialed number on CDR

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

133
Views
0
Helpful
4
Replies
CreatePlease to create content