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

[Lelio Fulgenzi]

Thanks Wes! Good to know. 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
Cooking with unix is easy. You just sed it and forget it. 
- LFJ (with apologies to Mr. Popeil) 


----- Original Message -----
From: "Wes Sisk" <wsisk at cisco.com> 
To: "Lelio Fulgenzi" <lelio at uoguelph.ca> 
Cc: "William Burnam" <WBurnam at mapei.com>, cisco-voip at puck.nether.net 
Sent: Monday, April 18, 2011 2:47:58 PM 
Subject: Re: [cisco-voip] search 911 call via CAR (CUCM 7) 

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 > 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/20110418/f6e48e76/attachment.html>