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. And see here for current known issues.

New Member

How to Run Queries, Informix CCM 6

Hi All,

We use to use SQL to run advanced queries and reports on our cdr database for particular extensions. We recently upgraded to ccm6 and don't really have any idea how to connect to and query the new database on the Linux OS. Do you have any suggestions, and do I have to purchase software in order to do this?

Thanks

7 REPLIES
Cisco Employee

Re: How to Run Queries, Informix CCM 6

You still can

run sql

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_0_1/cucos/iptpappa.html#wp1052698

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: How to Run Queries, Informix CCM 6

So I would log into the CLI, and use the sql command? Could I output the results to a file or would it just show on the screen? Ideally I want it like sql queries on the sql db. Where I can select all calls to or from a particular extension and then send the reports to a csv...

Thanks for the help.

Cisco Employee

Re: How to Run Queries, Informix CCM 6

It only shows in the screen but you can use something like putty to capture the output and then process it however you want

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: How to Run Queries, Informix CCM 6

Ok, that makes sense. Sorry, one more question.

In SQL I would enter" Select * from cdr where caller_number = xxxx"

Is the database the same name, and are the fields all the same as well? My example isn't 100% accurate :).

Thanks

Cisco Employee

Re: How to Run Queries, Informix CCM 6

Example

run sql select * from car:tbl_billing_data where originalcalledpartynumber='911'

Most of the fields remain the same

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: How to Run Queries, Informix CCM 6

Great, thank you.

I have another question though. Are there any free or not free third party reporting tools that people use to run these reports?

Cisco Employee

Re: How to Run Queries, Informix CCM 6

http://www.cisco.com/pcgi-bin/ctdp/Search.pl

Enter a Solution -> IP Communications -> Accounting/billing -> Not applicable -> Search

You'll get a list of partners developing solutions for CAR.

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
464
Views
5
Helpful
7
Replies
CreatePlease login to create content