CDR table name, SQL database name in ccm 7

uniccnp · ‎06-18-2009

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

Jaime Valencia · ‎06-18-2009

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

HTH

java

if this helps, please rate

uniccnp · ‎06-19-2009

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

j.mccartney · ‎07-09-2009

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

daveaton · ‎05-19-2012

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.