[cisco-voip] CDR/CAR database access from AXL/Soap in CUCM 8.x

Robert Hass robhass at gmail.com
Fri Dec 2 11:41:05 EST 2011


On Fri, Dec 2, 2011 at 4:34 PM, Wes Sisk <wsisk at cisco.com> wrote:
> via AXL you can execute any SQL query:
> http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/devguide/6_0_1/ccmdvCh1.html#wp73666
>
> though you raise a good point, i've not tried querying the CAR database this way

Standard SQL queries works for me without problems. But I'm unable to
find out how to access CAR database.
I tried two kind of queries:

SELECT originalcalledpartynumber,clientmattercode,datetimeorigination
FROM tbl_billing_data
Error: The specified table (tbl_billing_data) is not in the database.

SELECT originalcalledpartynumber,clientmattercode,datetimeorigination
FROM car:tbl_billing_data
Error: Database not found or no system permission.

car SELECT originalcalledpartynumber,clientmattercode,datetimeorigination
FROM tbl_billing_data
A syntax error has occurred.

So I don't have Any how to access CAR DB.

Robert


More information about the cisco-voip mailing list