<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>Thanks Wes! Good to know.<span><br><br><span name="x"></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>Cooking with unix is easy. You just sed it and forget it. <br> - LFJ (with apologies to Mr. Popeil)<br><span name="x"></span><br></span><br><hr id="zwchr"><b>From: </b>"Wes Sisk" <wsisk@cisco.com><br><b>To: </b>"Lelio Fulgenzi" <lelio@uoguelph.ca><br><b>Cc: </b>"William Burnam" <WBurnam@mapei.com>, cisco-voip@puck.nether.net<br><b>Sent: </b>Monday, April 18, 2011 2:47:58 PM<br><b>Subject: </b>Re: [cisco-voip] search 911 call via CAR (CUCM 7)<br><br>
When a record falls through CAR's parsing rules it goes into the
error table.<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_5_1/car/carsyerr.html" target="_blank">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_5_1/car/carsyerr.html</a><br>
<br>
Examples include:<br>
CDR duration < 0 <br>
CDR callingPartyNumber is empty <br>
<br>
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.<br>
<br>
Regards,<br>
Wes<br>
<br>
On 4/15/2011 7:11 PM, Lelio Fulgenzi wrote:
<blockquote cite="mid:9B135323-228D-43BC-84B0-E38042D0AB7E@uoguelph.ca">
<div>What's the error table?<br>
<br>
Sent from my iPhone</div>
<div><br>
On Apr 15, 2011, at 6:04 PM, Wes Sisk <<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>>
wrote:<br>
<br>
</div>
<blockquote>
<div> CAR cdr search may not search the error table. I believe
this will work from the CLI on the publisher:<br>
<br>
run sql car select
callingpartynumber,origdevicename,finalcalledpartynumber from
tbl_billing_data where finalcalledpartynumber like '%911'<br>
<br>
run sql car select
callingpartynumber,origdevicename,finalcalledpartynumber from
tbl_billing_error where finalcalledpartynumber like '%911'<br>
<br>
<br>
Note the 2 queries hit 2 different tables.<br>
<br>
Regards,<br>
Wes<br>
<br>
On 4/15/2011 2:10 PM, Burnam, William wrote:
<blockquote cite="mid:3340384891CC834CA3F7E81FF66B967808673DF5@usflmiex03.mapei.group">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Script MT Bold";
panose-1:3 4 6 2 4 6 7 8 9 4;}
@font-face
{font-family:"Century Schoolbook";
panose-1:2 4 6 4 5 5 5 2 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hello All,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal">Bill</p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 14pt; font-family: "Script MT Bold";"><mime-attachment.jpg></span><span style="font-size: 12pt;"></span></p>
<p class="MsoNormal"><span style="font-size: 14pt; font-family: "Script MT Bold";">Bill Burnam</span></p>
<p class="MsoNormal">Systems Engineer, IT<span style="font-size: 12pt;"></span></p>
<p class="MsoNormal">MAPEI Corp.</p>
<p class="MsoNormal">1144 E. Newport Center Drive</p>
<p class="MsoNormal">Deerfield Beach, FL 33442</p>
<p class="MsoNormal">(954) 246-8703</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><u><span style="font-size: 7.5pt; color: rgb(64, 128, 128);">CONFIDENTIALITY NOTICE</span></u></p>
<p class="MsoNormal" style=""><span style="font-size: 7.5pt;">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</span><span style="font-size: 7.5pt;">. </span></p>
<p class="MsoNormal"> </p>
</div>
<font color="#000000">
<h5><br>
<hr>
------------------------------------------------------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. <br>
<hr></h5>
</font>
<pre><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
cisco-voip mailing list
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</div>
</blockquote>
<blockquote>
<div><span>_______________________________________________</span><br>
<span>cisco-voip mailing list</span><br>
<span><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></span><br>
<span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br>
</div>
</blockquote>
</blockquote>
</div></body></html>