Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

CDR and DB query

Hi,

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

4 REPLIES
Silver

Re: CDR and DB query

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

New Member

Re: CDR and DB query

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,

Cisco Employee

Re: CDR and DB query

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
Silver

Re: CDR and DB query

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

298
Views
0
Helpful
4
Replies
CreatePlease to create content