[cisco-voip] Who called 911

[Jonathan Charles]

You will also want to search for 9911 (or whatever your access code is)...

I am not sure if FinalCalledParty includes the digit strip...


Jonathan


On 2/12/07, Erick Bergquist <erickbe at yahoo.com> wrote:
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070213/8a56702a/attachment.html