If I wanted to do an SQL search in CUCM6.1.2 for calls made by a particular partition what would I use for table name?
The partition we have setup for some users is: pt-Hastings
So I was wondering how do I list my query:
run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber, duration, datetimestamporigination, datetimestampdisconnect, "partition(??)" from car:tbl_billing_data where "partiton" IN ('pt-Hastings')
Sorry, was to quick..You want CDR ...
callingPartyNumber = 5 Digit Extension Number of the Calling Party
originalCalledPartyNumber = 5 Digit Extension or Longdial Number with 0 for Access Code or 97xxx
finalCalledPartyNumber = 5 Digit Extension or Longdial Number with 0 for Access Code or 97xxx
originalCalledPartyNumberPartition = example P-Trunk-Select
callingPartyNumberPartition = example P-IPphones
finalCalledPartyNumberPartition = example P-Trunk-Select
origDeviceName = SEPxxxxxxxxxxxx 12 Digit in Capitals
destDeviceName = example [email protected]
select * from CallDetailRecord where callingPartyNumber='58999'
gives you exactly all calls made by calling Party 58999
select * from CallDetailRecord where callingPartyNumber like '5899%'
gives you calls made by the digits before the % and
any length behind it.
0004969% would cover all calls to Frankfurt Area Code Germany
select * from CallDetailRecord where finalCalledPartyNumber like '0004969713671_8'
would give you the exact range from
0->9 before the last digit