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

[Lelio Fulgenzi]

What's the error table?

Sent from my iPhone

On Apr 15, 2011, at 6:04 PM, Wes Sisk <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
>> https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> _______________________________________________
> cisco-voip mailing list
> 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/20110415/778e14e7/attachment.html>