CDR and DB query

Unanswered Question
Mar 3rd, 2009


I would like to write a query tool (I knew php, retrieve data from CDR. Any hint? Thanks,

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Tim Smith Wed, 03/04/2009 - 22:29


What version of CCM?

What info do you want?

Prior to v 5.x it is in a SQL database, very easy to query. Usually it is on the pub.. but it doesnt have to be.

5.x and above it actually FTP's the CDR record to an off box location, you need to collect them and store / process them.

Lookup the CDR definition for the version you are using.. you will find some pretty good docco.



smallrain_2 Thu, 03/05/2009 - 13:07


Thanks for your reply. We are suing CCM6.

I want, for example, current active calls, PRI channel utilization and etc.

My goal is to retrieve and display the only info I interested in.


Tim Smith Sat, 03/07/2009 - 20:41


Ah ok..

That is not really CDR.. CDR is more a record of each call made and it's detais.

You can use RTMT client to get an idea of what counters are available.

And then as Java says below.. lookup the programming guide for AXL and AXL serviceability. They should give you what you want.




This Discussion