CDR table name, SQL database name in ccm 7

Unanswered Question
Jun 18th, 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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Jaime Valencia Thu, 06/18/2009 - 06:26

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

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

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

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

Actions

This Discussion