[cisco-voip] Who called 911

[Erick Bergquist]

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