How to Query Data base in Cisco CCM 6.x

Unanswered Question
Mar 26th, 2008

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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
gogasca Wed, 03/26/2008 - 11:17

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 --------------------

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

gogasca,

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

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

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

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

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.

Thanks

gogasca Wed, 03/26/2008 - 14:33

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

Cheers

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

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

thanks

gogasca Wed, 03/26/2008 - 11:45

file list activelog /cm/cdr_repository/

In preserve folder we store the files for 30 days

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

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

OR

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

Actions

This Discussion