Sunday 23 September 2012

CDR Report from CUCM CLI (ISD,STD and Local)


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'

No comments:

Post a Comment