<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[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";"><img id="Picture_x0020_1"
src="cid:part1.07070401.05050503@cisco.com"
alt="Description: cid:image001.jpg@01CACCCA.108F0930"
width="160" height="37"></span><span style="font-size:
12pt; font-family: "Times New
Roman","serif";"><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; font-family: "Times New
Roman","serif";"><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; font-family: "Century
Schoolbook","serif"; color: rgb(64, 128,
128);">. <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 class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</body>
</html>