CDR report from CLI

[Abhishek Singh]

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       

[Abhishek Singh]

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

[Abhishek Singh]

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