1 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-09-22 00:00:00' and '2011-09-23 23:59:59'
2 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-09-22 00:00:00' and '2012-09-23 00:00:00'
3 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-09-23 17:20:00' and '2012-09-23 17:35:00'
