CAR Database tables in CUCM 10.5

[Mohsin Khan Feroz]

Hello Friends,

Till 9.x the CAR tables in the CUCM was present in CAR:Tbl_Billing_data but I heard the from 10.5 onwards, its been moved to a different table so the command

run sql select * from car:tbl_billing_data will not work. Can you guys advice the new command to pull the CDR from CLI?

Thanks.

[Mohsin Khan Feroz · Accepted solution]

I got it worked.. The new command is..

run sql car select * from tbl_billing_data where originalcalledpartynumber='<extNumber>'

[gersomor1]

Hello,

Here I share another example a little more specific that you can use to check data from CDR using CLI instead or using CAR or normal Call Manager traces. (Something I love since I was in TAC)

Below you would be able to fine 2 examples that might help you to understand and create your own sql query's.

Syntax:

run sql car select + column + from car:tbl_billing_data where + column + (like,in,between,etc).

Example:

run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750")

This will provide the  calls where the calling party number was 7140 and 5750 for example.

Result:

call_type callingpartynumber originalcalledpartynumber datetimestamporigination
========= ================== ========================= ========================
S         5750               1208743XXXX               2018-02-05 15:23:10      
S         5750               1209401XXXX              2018-02-05 11:47:56 

You can also use a Date Range by adding the "and" and "Between" statement as the example below:

run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750") and  datetimestamporigination between "2018-03-01 00:00:00" and "2018-03-29 23:00:00"

Thanks,

Gerson Morales Marin