You will also want to search for 9911 (or whatever your access code is)...<br><br>I am not sure if FinalCalledParty includes the digit strip...<br><br><br>Jonathan<br><br><br><div><span class="gmail_quote">On 2/12/07, <b class="gmail_sendername">
Erick Bergquist</b> <<a href="mailto:erickbe@yahoo.com">erickbe@yahoo.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
You can use CDR Tools And Analysis web page and do a CDR Search for 911 or 9911, that searches called and calling party numbers but only displays 100 records.<br><br>Or this SQL Query, replace 911 with 9911 if you use that or combine them.
<br><br>USE<br>CDR<br>SELECT callingPartyNumber,originalCalledPartyNumber, finalCalledPartyNumber, duration<br><br>FROM CallDetailRecord<br><br>WHERE (((originalCalledPartyNumber)="911"))<br><br>----- Original Message ----
<br><br><br>From: Jason Burwell <<a href="mailto:BurwellJ@firstcharter.com">BurwellJ@firstcharter.com</a>><br><br>To: <a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><br>Sent: Monday, February 12, 2007 3:20:11 PM
<br><br>Subject: [cisco-voip] Who called 911<br><br><br><br> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:
12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17
{ font-family:Arial; color:windowtext;} _filtered { margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {} --> Hello,<br><br><br><br> Can someone remind me how to find what user dialed 911 in the system? If I recall this information is on the Publisher somewhere in SQL.
<br><br><br><br> I am running CCM 4.1(3)es91.<br><br><br><br> Thanks!<br><br> Jason<br><br><br><br> Jason T. Burwell<br><br> Infrastructure/Telecommunications<br><br> First Charter Bank<br><br> 10200 David Taylor Drive
<br><br> Charlotte, NC 28262<br><br> ph-704-688-4664<br><br> fax-704-688-4901<br><br> <a href="http://www.firstcharter.com">www.firstcharter.com</a><br><br><br><br><br><br> _______________________________________________
<br><br>cisco-voip mailing list<br><br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip
</a><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>____________________________________________________________________________________<br>Sucker-punch spam with award-winning protection.<br>Try the free Yahoo! Mail Beta.
<br><a href="http://advision.webevents.yahoo.com/mailbeta/features_spam.html">http://advision.webevents.yahoo.com/mailbeta/features_spam.html</a><br><br>_______________________________________________<br>cisco-voip mailing list
<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></blockquote></div>
<br>