International CDR Report from CUCM CLI

By using SQL query we would be able to generate CDR details from CUCM CLI

Here is the query for international calls

Partition= here you should have to mention your international partition

eg : -

run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,originalCalledPartyNumber from car: tbl_billing_data where finalCalledPartyNumberPartition='PT_Int' and datetimestamporigination between '2011-11-21 00:00:00' and '2011-11-26 23:59:59'

Here are the few more queries from CM 


run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,originalCalledPartyNumber from car: tbl_billing_data where datetimestamporigination between '2012-05-01 00:00:00' and '2012-06-02 00:00:00'

 =>This query will give you the details about call disconnection. run sql select 

run sql select datetimestampconnect,datetimestampdisconnect,duration,callingPartyNumber,origCause_value,originalCalledPartyNumber,destCause_value from car: tbl_billing_data where datetimestamporigination between '2012-03-30 17:20:00' and '2012-03-30 17:35:00'


 run sql select * from car:tbl_billing_data

run sql select * from car:tbl_billing_data where datetimestampconnect > '2011-04-15 11:02:25'

run sql select * from car:tbl_billing_data where originalcalledpartynumber like '%2966'

SQL CDR reporting in CUCM ver 8:

https://supportforums.cisco.com/thread/2087799

There are changes in the DB table. new format is given below

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

run sql car select * from car:tbl_billing_data where originalcalledpartynumber like '%2966'

https://community.cisco.com/t5/ip-telephony-and-phones/car-database-tables-in-cucm-10-5/td-p/3210520