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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CDR reports with external application

We have CCM 4.1.3 and we use a 3rd party app eGlue to pull reports from SQL (CDR) database.

We are in the process of upgrading to CUCM 6.x and I'm not sure how I can access the CDR databate, as it's on Informix and the appliance is locked down.

I read somewhere that I can use AXL, but I'm still not clear.

Any ideas?

thanks in adv,

:JoeL

6 REPLIES
Cisco Employee

Re: CDR reports with external application

you can also use SOAP to access CDR, there are already some 3rd party billing servers designed for linux appliances

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: CDR reports with external application

thanks...

is there a doc that shows how I can use SOAP to do this...do I have to be a programmer?

We are not able to purchase anything new.... I'm supposed to see if the existing app can pull reports from CUCM 6.x

:JoeL

Re: CDR reports with external application

it's easier to use the ftp push from the cucm.

Go to Serviceability -> Tools -> CDR Management

add a billing application server, just make sure you have ftp or sftp running on the receiving server

New Member

Re: CDR reports with external application

yes. I will also go with this approach of pushing cdr to an external ftp server. You can run a free ftp server software like freeftpd which will take care of both ftp server(for cdr management) and sftp server (scheduled backup & patch installation).

Cisco Employee

Re: CDR reports with external application

the guides we have are here:

Programming Guides

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

you can try the

# IP Phone Services for Developers

# IP Phone Services for End Users

forums to get some help on programming

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: CDR reports with external application

thanks for the responses guys...

I get the flat files through sftp fine..

I could not get anything from the programming reference...

I am trying to upload the flat files back to an SQL server, so that my users can run the same sql queries to obtain the reports...has anyone done this.?

I can get a few things to work but I'm still struggling getting multiple flat files to the same table, making sure that the column header doesn't get added multiple times, automating the process of running import wizard to import files to the database...

has anyone taken this crazy path...if so pls help..thanks..

joel

217
Views
2
Helpful
6
Replies