[cisco-voip] search 911 call via CAR (CUCM 7)

[Wes Sisk]

When a record falls through CAR's parsing rules it goes into the error 
table.

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_5_1/car/carsyerr.html

Examples include:
CDR duration < 0
CDR callingPartyNumber is empty

The original intent was for CAR to filter out erroneous events and 
system events from user view.  As with any filter it sometimes filters 
good information.

Regards,
Wes

On 4/15/2011 7:11 PM, Lelio Fulgenzi wrote:
> What's the error table?
>
> Sent from my iPhone
>
> On Apr 15, 2011, at 6:04 PM, Wes Sisk <wsisk at cisco.com 
> <mailto:wsisk at cisco.com>> wrote:
>
>> CAR cdr search may not search the error table.  I believe this will 
>> work from the CLI on the publisher:
>>
>> run sql car select 
>> callingpartynumber,origdevicename,finalcalledpartynumber from 
>> tbl_billing_data where finalcalledpartynumber like '%911'
>>
>> run sql car select 
>> callingpartynumber,origdevicename,finalcalledpartynumber from 
>> tbl_billing_error where finalcalledpartynumber like '%911'
>>
>>
>> Note the 2 queries hit 2 different tables.
>>
>> Regards,
>> Wes
>>
>> On 4/15/2011 2:10 PM, Burnam, William wrote:
>>>
>>> Hello All,
>>>
>>> I’m having a constant problem with users dialing 911 (by accident it 
>>> seems).  I need to pull records from CAR to show everyone in the 
>>> system that has dialed 911, but I’m not having any luck.  I can 
>>> search by a user’s extension and then sort through the records until 
>>> I find the CDR record that shows the 911 call, but I’m not sure how 
>>> I can simply search for ALL calls (all users) to 911 only.  For 
>>> reference I’m using CUCM 7.  Can anyone help out with this?
>>>
>>> Thanks,
>>>
>>> Bill
>>>
>>> <mime-attachment.jpg>
>>>
>>> Bill Burnam
>>>
>>> Systems Engineer, IT
>>>
>>> MAPEI Corp.
>>>
>>> 1144 E. Newport Center Drive
>>>
>>> Deerfield Beach, FL 33442
>>>
>>> (954) 246-8703
>>>
>>> _CONFIDENTIALITY NOTICE_
>>>
>>> THIS COMMUNICATION, INCLUDING ANY ATTACHMENT, CONTAINS INFORMATION 
>>> THAT IS CONFIDENTIAL AND THAT MAY ALSO BE LEGALLY PRIVILEGED, AND IS 
>>> INTENDED ONLY FOR THE EXCLUSIVE USE OF THE INDIVIDUAL NAMED AS THE 
>>> RECIPIENT.  IF THE READER OF THIS MESSAGE IS NOT THE INTENDED 
>>> RECIPIENT, YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR AND ANY 
>>> REVIEW, DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION 
>>> OR ANY ATTACHMENT TO THIS TRANSMISSION IS STRICTLY PROHIBITED.  IF 
>>> YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE IMMEDIATELY 
>>> NOTIFY THE SENDER BY REPLY E-MAIL AND DELETE AND DESTROY ALL COPIES 
>>> OF THE ORIGINAL MESSAGE.  THANK YOU.
>>>
>>>
>>>
>>>           ------------------------------------------------------------------------
>>>           ------------------------------------------------------CONFIDENTIALITY
>>>           NOTICE
>>>           ---------------------------------------------------- THIS
>>>           COMMUNICATION, INCLUDING ANY ATTACHMENT, CONTAINS
>>>           INFORMATION THAT IS CONFIDENTIAL AND IS INTENDED ONLY FOR
>>>           THE EXCLUSIVE USE OF THE INDIVIDUAL NAMED AS THE
>>>           RECIPIENT. IF THE READER OF THIS MESSAGE IS NOT THE
>>>           INTENDED RECIPIENT, YOU HAVE RECEIVED THIS TRANSMISSION IN
>>>           ERROR AND ANY REVIEW, DISSEMINATION, DISTRIBUTION OR
>>>           COPYING OF THIS COMMUNICATION OR ANY ATTACHMENT TO THIS
>>>           TRANSMISSION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED
>>>           THIS TRANSMISSION IN ERROR, PLEASE IMMEDIATELY NOTIFY THE
>>>           SENDER BY REPLY E-MAIL AND DELETE AND DESTROY ALL COPIES
>>>           OF THE ORIGINAL MESSAGE. THANK YOU.
>>>           ------------------------------------------------------------------------
>>>
>>>
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net  <mailto:cisco-voip at puck.nether.net>
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
>> https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110418/a6ebdab1/attachment.html>