11-05-2007 10:41 AM - edited 03-15-2019 07:04 AM
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?
11-05-2007 02:21 PM
What version of call manager?
11-06-2007 02:15 AM
Version 4.2(3)sr2b
11-06-2007 12:57 PM
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--
11-07-2007 05:36 AM
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!!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide