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

[Miller, Steve]

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
==============================================================================