cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1340
Views
5
Helpful
2
Replies
Highlighted
Cisco Employee

CDR report from CLI

Hi,

Can someone please confirm on how can we fetch the outgoing calls from a particular extension on a particular day through a CLI - SQL query.

Went through some of the doucmentations pointing towards certain specific queries--  but would like to sureshot on this front as this is for a particularly important individual on the clients side. Appreciate some help on this.

Thanks.

http://www.ucguerrilla.com/2012/03/cucm-sql-queries-installment-5.html

http://mmm-cisco.blogspot.in/2012/09/cdr-report-from-cucm-cli-isdstd-and.html

Whatever level you reach getting better never stops -- Sachin Tendulkar       

Whatever level you reach getting better never stops -- Sachin Tendulkar
Everyone's tags (6)
2 REPLIES 2
Cisco Employee

CDR report from CLI

For called party we have the following command as we know ::

run sql select * from car:tbl_billing_data where originalcalledpartynumber='extension you want report for'

==============================================================================

Require information for calling number for a particular date.

Thanks.

Whatever level you reach getting better never stops -- Sachin Tendulkar

Whatever level you reach getting better never stops -- Sachin Tendulkar
Cisco Employee

CDR report from CLI

admin:run sql car select callingPartyNumber,finalCalledPartyNumber,origDeviceName, destDeviceName,origCallTerminationOnBehalfOf,destCallTerminationOnBehalfOf, datetimeorigination, datetimeconnect,datetimedisconnect from tbl_billing_data where (callingPartyNumber = 'xxxxx' or finalCalledPartyNumber='xxxxxx' ) AND datetimeorigination > 'xxxxxx' AND datetimeorigination<'xxxxxxxx'

callingpartynumber finalcalledpartynumber origdevicename  destdevicename origcallterminationonbehalfof destcallterminationonbehalfof datetimeorigination datetimeconnect datetimedisconnect

This is the command

Whatever level you reach getting better never stops -- Sachin Tendulkar

Whatever level you reach getting better never stops -- Sachin Tendulkar
CreatePlease to create content
Content for Community-Ad
July's Community Spotlight Awards