How to Query Data base in Cisco CCM 6.x

Unanswered Question
Mar 26th, 2008
User Badges:

In previous version of Cisco call manager you could use a SQL data base tool and query tables. Does anyone know what you can use in the latest 6.x version of CCM to query data base tables.

Thank you very much

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
gogasca Wed, 03/26/2008 - 11:17
User Badges:
  • Green, 3000 points or more

1) List tables for CM DB

admin:show tech systables

2) Send contents of a particular table to a file

admin:show tech table numplan

-------------------- show tech table --------------------


Output is in file cm/trace/dbl/sdi/numplan_table.16103.csv

3) you can download the file using sftp

4) Under SSH use run sql command

GregL Wed, 03/26/2008 - 11:25
User Badges:


What the Client wants is an easy way to extract the CDR information out. May like a csv file or something.

Like in the older CCM 4.x you could look at the SQL data base in the sql server enterprise manager location.

any ideas.

gogasca Wed, 03/26/2008 - 11:28
User Badges:
  • Green, 3000 points or more

We have an option for moving CDR records to external SFTP

CDR DB no longer exists in Linux version, we only use flat files

Check CDR options in CCM serviceability

GregL Wed, 03/26/2008 - 11:32
User Badges:

Customer doesnt want to do it that way. They want to write it themselves

Any other ideas.

Thank you

gogasca Wed, 03/26/2008 - 11:36
User Badges:
  • Green, 3000 points or more

He can extract file by file

by using file get ? option...

Pervious option was the easies way nnot sure why they dont want to doit that way

Other option is 3rd party billing using SOAP

GregL Wed, 03/26/2008 - 11:45
User Badges:

Is the CDRdetailrecords still in a database by it self.

Also what is the tables to extract that would give them this information.

2nd question is:

using the longest idle algarythem you want to show the ringing phone on the original calling phone on internal calls .

this used to work in version 4.x but we seem to not see this in 6.0 and ideas.


gogasca Wed, 03/26/2008 - 14:33
User Badges:
  • Green, 3000 points or more

Is the CDRdetailrecords still in a database by it self.

Also what is the tables to extract that would give them this information.

I answered that in my previous post

We no longer have CDR DB only flat files

What exactly you are seeing?

Explain me the call flow please


GregL Wed, 03/26/2008 - 14:38
User Badges:

i was able to do the get file command and pull out the data file 20080326 and i think they said they could work with that.

what is weird is i looked at the file 20080325 which i would have assumed was yesterday but it was empty. the only file that has anything in it is 20080326. which i assume is todays


gogasca Wed, 03/26/2008 - 11:45
User Badges:
  • Green, 3000 points or more

file list activelog /cm/cdr_repository/

In preserve folder we store the files for 30 days

GregL Wed, 03/26/2008 - 11:57
User Badges:

hey gogasca. Did you see my last question?

mohammad.elshafie Sun, 04/06/2008 - 01:46
User Badges:

Please, I need help in this case.

The customer need to use a third party billing system for the CDR of Callmanger 6.0.

The problem that the database of the Callmanager not SQL like the previous versions.

The engineer that will install the billing system asked me for two ways to help to collect the data from CDR:

first: to know the path of the database so he can go through it and collect the data by himself using the billing system


Second: the CDR sent a report with all details every 1 min. to the server of the billing system and he will deal with it.

please I tried many steps but it is failed.

So if any know how to do this??

thanks so much

Anonymous (not verified) Mon, 04/07/2008 - 05:11
User Badges:


This Discussion