06-18-2009 05:01 AM - edited 03-15-2019 06:36 PM
Hi
I would like to know what is the CDR table name and SQL database name in ccm (lunix ver 5,6,7) to pull some of information ???
thanks and regards
06-18-2009 06:26 AM
Drop the idea of CDR and SQL if you're talking of appliances models.
Only CAR DB exists and we use Informix.
Look at this example:
run sql select * from car:tbl_billing_data where originalcalledpartynumber='911'
HTH
java
if this helps, please rate
06-19-2009 08:44 AM
hi
thanks for your cooperation
please can you send to me Link or PDF that showing me what the DB name and SQL name and type of SQL to pull it
thanks and regards
07-09-2009 12:53 PM
OK thanks. I think I've ruled it out as our faxing application (Stream) as I can't find a call in the trace files either to the extension for a 20 minute time period that it was happening. Thanks as usual for your help; it's appreciated
05-19-2012 10:28 PM
Cisco Call Detail Records Field Descriptions
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_0_1/cdr-defs/cdrfdes.html
CDR Examples
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/7_0_1/cdr-defs/cdrex.html
Table name as listed above "car:tbl_billing_data"
Hope this helps.
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