06-08-2009 03:05 PM - edited 03-15-2019 06:25 PM
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
06-08-2009 03:22 PM
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
06-09-2009 06:44 AM
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.
06-09-2009 06:58 AM
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
06-09-2009 07:06 AM
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
06-09-2009 07:14 AM
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
06-09-2009 07:19 AM
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?
06-09-2009 07:24 AM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: