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

[Marc.Walker at btengageit.com]

Hi Robert,

In version 7 I use queries from the cli as below:

run sql select
callingpartynumber,originalcalledpartynumber,datetimeorigination from
car:tbl_billing_data where originalcalledpartynumber = '90800xxxxxx'
order by datetimeorigination desc

Not sure if this is the same for version 8. There is some document on
the web that lists all the entries in the tables, just search for one of
the above.

Hope this helps

Marc

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Robert Hass
Sent: 02 December 2011 16:41
To: Wes Sisk
Cc: cisco-voip
Subject: Re: [cisco-voip] CDR/CAR database access from AXL/Soap in CUCM
8.x

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/ccmd
> vCh1.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
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

 -
This email has been scanned by MessageLabs Email Security.

IT solutions for business from BT Engage IT

Providing businesses with one of the most comprehensive IT services portfolios in the market.  Find out more @ http://www.btengageit.com/

This email contains BT Engage IT information, which may be privileged or confidential. It's meant only for the individual(s) or entity named above. If you're not the intended recipient, note that disclosing, copying, distributing or using this information is prohibited. If you've received this email in error, please let me know immediately on the email address above. Thank you. We monitor our email system, and may record your emails. 

BT Engage IT Limited
Registered office: No 1 Avenue One, Letchworth Business Park, Letchworth Garden City, Hertfordshire, SG6 2HB
Registered in England no: 02277581

 -
This email has been scanned by MessageLabs Email Security.