<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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">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"
type="cite">
<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
moz-do-not-send="true" href="mailto:wsisk@cisco.com">wsisk@cisco.com</a>>
wrote:<br>
<br>
</div>
<blockquote type="cite">
<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"
type="cite">
<!--[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,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Bill<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 10pt;
font-family:
"Arial","sans-serif";"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 14pt;
font-family: "Script MT Bold";"><mime-attachment.jpg></span><span
style="font-size: 12pt;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 14pt;
font-family: "Script MT Bold";">Bill Burnam<o:p></o:p></span></p>
<p class="MsoNormal">Systems Engineer, IT<span
style="font-size: 12pt;"><o:p></o:p></span></p>
<p class="MsoNormal">MAPEI Corp.<o:p></o:p></p>
<p class="MsoNormal">1144 E. Newport Center Drive<o:p></o:p></p>
<p class="MsoNormal">Deerfield Beach, FL 33442<o:p></o:p></p>
<p class="MsoNormal">(954) 246-8703<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><u><span style="font-size: 7.5pt;
color: rgb(64, 128, 128);">CONFIDENTIALITY NOTICE<o:p></o:p></span></u></p>
<p class="MsoNormal" style=""><span style="font-size:
7.5pt; font-family: "Times New
Roman","serif"; color: rgb(64, 128,
128);">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;">. <o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<font bgcolor="#ffffff" 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 wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
cisco-voip mailing list
<a moz-do-not-send="true" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a moz-do-not-send="true" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>cisco-voip mailing list</span><br>
<span><a moz-do-not-send="true"
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></span><br>
<span><a moz-do-not-send="true"
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br>
</div>
</blockquote>
</blockquote>
</body>
</html>