Well, you could do a SQL query to the CDR database and then sort by called number, export to a csv and check...<br><br><br><br>Jonathan<br><br><div><span class="gmail_quote">On 2/13/07, <b class="gmail_sendername">Miller, Steve
</b> <<a href="mailto:MillerS@dicksteinshapiro.com">MillerS@dicksteinshapiro.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;">
There must be a way to see the most popular OUTGOING calls on my system,<br>but I can't find it in the CDR. Please let me know what I am missing.<br>Thank you!<br><br><br>Steve Miller<br>Telecom Engineer<br>Dickstein Shapiro LLP
<br>1825 Eye Street NW | Washington, DC 20006<br>Tel (202) 420-3370 Fax (202)-330-5607<br><a href="mailto:millers@dicksteinshapiro.com">millers@dicksteinshapiro.com</a><br><br><br>-----Original Message-----<br>From: <a href="mailto:cisco-voip-bounces@puck.nether.net">
cisco-voip-bounces@puck.nether.net</a><br>[mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>] On Behalf Of Erick Bergquist<br>Sent: Tuesday, February 13, 2007 12:08 AM<br>To: Jason Burwell;
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>Subject: Re: [cisco-voip] Who called 911<br><br>You can use CDR Tools And Analysis web page and do a CDR Search for 911<br>or 9911, that searches called and calling party numbers but only
<br>displays 100 records.<br><br>Or this SQL Query, replace 911 with 9911 if you use that or combine<br>them.<br><br>USE<br>CDR<br>SELECT callingPartyNumber,originalCalledPartyNumber,<br>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 */
<br>p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in;<br>margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";}<br>a:link, span.MsoHyperlink {color:blue; text-decoration:underline;}
<br>a:visited, span.MsoHyperlinkFollowed {color:purple;<br>text-decoration:underline;} span.EmailStyle17 { font-family:Arial;<br>color:windowtext;} _filtered { margin:1.0in 1.25in 1.0in 1.25in;}<br>div.Section1 {} --> Hello,
<br><br><br><br> Can someone remind me how to find what user dialed 911 in the<br>system? If I recall this information is on the Publisher somewhere in<br>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>____________<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><br><br>--------------------------------------------------------
<br>This e-mail message and any attached files are confidential and are intended solely for the use of the addressee(s) named above. This communication may contain material protected by attorney-client, work product, or other privileges. If you are not the intended recipient or person responsible for delivering this confidential communication to the intended recipient, you have received this communication in error, and any review, use, dissemination, forwarding, printing, copying, or other distribution of this e-mail message and any attached files is strictly prohibited. Dickstein Shapiro reserves the right to monitor any communication that is created, received, or sent on its network. If you have received this confidential communication in error, please notify the sender immediately by reply e-mail message and permanently delete the original message.
<br><br>To reply to our email administrator directly, send an email to <a href="mailto:postmaster@dicksteinshapiro.com">postmaster@dicksteinshapiro.com</a><br><br>Dickstein Shapiro LLP<br><a href="http://www.DicksteinShapiro.com">
http://www.DicksteinShapiro.com</a><br>==============================================================================<br><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>