CDR table name, SQL database name in ccm 7

Unanswered Question
Jun 18th, 2009
User Badges:


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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Jaime Valencia Thu, 06/18/2009 - 06:26
User Badges:
  • Cisco Employee,
  • Hall of Fame,


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'



if this helps, please rate

uniccnp Fri, 06/19/2009 - 08:44
User Badges:


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 Thu, 07/09/2009 - 12:53
User Badges:

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


This Discussion