CDR and DB query

[smallrain_2]

Hi,

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

[Tim Smith]

Hi,

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.

Cheers,

Tim

[smallrain_2]

Tim,

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.

Thanks,

[Jaime Valencia]

start by reading this:

Cisco Unified Communications Manager (CallManager)

Programming Guides

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

HTH

java

if this helps, please rate

[Tim Smith]

Hi,

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.

Cheers,

Tim