[cisco-voip] Most Dialed Outgoing Calls???

[Jonathan Charles]

Well, you could do a SQL query to the CDR database and then sort by called
number, export to a csv and check...



Jonathan

On 2/13/07, Miller, Steve <MillerS at dicksteinshapiro.com> wrote:
>
> There must be a way to see the most popular OUTGOING calls on my system,
> but I can't find it in the CDR.  Please let me know what I am missing.
> Thank you!
>
>
> Steve Miller
> Telecom Engineer
> Dickstein Shapiro LLP
> 1825 Eye Street NW | Washington, DC 20006
> Tel (202) 420-3370 Fax (202)-330-5607
> millers at dicksteinshapiro.com
>
>
> -----Original Message-----
> From: cisco-voip-bounces at puck.nether.net
> [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Erick Bergquist
> Sent: Tuesday, February 13, 2007 12:08 AM
> To: Jason Burwell; cisco-voip at puck.nether.net
> Subject: Re: [cisco-voip] Who called 911
>
> 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.
>
> Or this SQL Query, replace 911 with 9911 if you use that or combine
> them.
>
> USE
> CDR
> SELECT callingPartyNumber,originalCalledPartyNumber,
> finalCalledPartyNumber, duration
>
> FROM CallDetailRecord
>
> WHERE (((originalCalledPartyNumber)="911"))
>
> ----- Original Message ----
>
>
> From: Jason Burwell <BurwellJ at firstcharter.com>
>
> To: cisco-voip at puck.nether.net
>
> Sent: Monday, February 12, 2007 3:20:11 PM
>
> Subject: [cisco-voip] Who called 911
>
>
>
>                                        <!--    /* 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,
>
>
>
>          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.
>
>
>
>      I am running CCM 4.1(3)es91.
>
>
>
>      Thanks!
>
>      Jason
>
>
>
>      Jason T. Burwell
>
>      Infrastructure/Telecommunications
>
>      First Charter Bank
>
>      10200 David    Taylor Drive
>
>      Charlotte,  NC 28262
>
>      ph-704-688-4664
>
>      fax-704-688-4901
>
>      www.firstcharter.com
>
>
>
>
>
>     _______________________________________________
>
> cisco-voip mailing list
>
> cisco-voip at puck.nether.net
>
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ________________________________________________________________________
> ____________
> Sucker-punch spam with award-winning protection.
> Try the free Yahoo! Mail Beta.
> http://advision.webevents.yahoo.com/mailbeta/features_spam.html
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
> --------------------------------------------------------
> 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.
>
> To reply to our email administrator directly, send an email to
> postmaster at dicksteinshapiro.com
>
> Dickstein Shapiro LLP
> http://www.DicksteinShapiro.com
>
> ==============================================================================
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070213/245c524e/attachment-0001.html