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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CDR table name, SQL database name in ccm 7

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

4 REPLIES
Cisco Employee

Re: CDR table name, SQL database name in ccm 7

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

www.cisco.com/go/pdi
New Member

Re: CDR table name, SQL database name in ccm 7

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

New Member

Re: CDR table name, SQL database name in ccm 7

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

Cisco Employee

Re: CDR table name, SQL database name in ccm 7

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.

475
Views
0
Helpful
4
Replies