do a CDR dump for the date(s) your looking for.<div><br></div><div>save as the TXT file</div><div><br></div><div>open in excel and delimate by comma.</div><div><br></div><div>search final called number to the 911 call.</div>
<div><br></div><div>scroll over to the Calling party number.</div><div><br></div><div>your done.</div><div><br></div><div>Now for some other comments.</div><div><br></div><div>if you have a DB guy, you can SFTP the CDR's off box, and then put them into a SQL DB. have it searched every 1 minute and then email you in the case of a 911 call including the called party, time, length of call. we have done this in the past at my old job and now at my new job, we have a CDR software that does the same...... Now the negative is that it does not alert until after the call is completed. we would have the email also go the the receptionist so they knew.</div>
<div><br></div><div>CER or other E911 solutions will do it in real time. We are piloting CER currently, and it works nice.</div><div><br></div><div>I heard at my last job the 911 calls got so bad that they changed to 8 and the access code to help.</div>
<div><br></div><div>YMMV</div><div><br></div><div>Scott<br><br><div class="gmail_quote">On Fri, Apr 15, 2011 at 11:10 AM, Burnam, William <span dir="ltr"><<a href="mailto:WBurnam@mapei.com">WBurnam@mapei.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal">Hello All,</p><p class="MsoNormal"> </p><p class="MsoNormal">
I’m having a constant problem with users dialing 911 (by accident it seems). I need to pull records from CAR to show everyone in the system that has dialed 911, but I’m not having any luck. I can search by a user’s extension and then sort through the records until I find the CDR record that shows the 911 call, but I’m not sure how I can simply search for ALL calls (all users) to 911 only. For reference I’m using CUCM 7. Can anyone help out with this?</p>
<p class="MsoNormal"> </p><p class="MsoNormal">Thanks,</p><p class="MsoNormal">Bill</p><p class="MsoNormal"><span style="font-size:10.0pt"> </span></p><p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Script MT Bold""><img width="160" height="37" src="cid:image001.jpg@01CBFB49.C6413E20" alt="Description: cid:image001.jpg@01CACCCA.108F0930"></span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Script MT Bold"">Bill Burnam</span></p><p class="MsoNormal">Systems Engineer, IT<span style="font-size:12.0pt;font-family:"Times New Roman","serif""></span></p>
<p class="MsoNormal">MAPEI Corp.</p><p class="MsoNormal">1144 E. Newport Center Drive</p><p class="MsoNormal">Deerfield Beach, FL 33442</p><p class="MsoNormal"><a href="tel:%28954%29%20246-8703" value="+19542468703" target="_blank">(954) 246-8703</a></p>
<p class="MsoNormal"> </p><p class="MsoNormal"><u><span style="font-size:7.5pt;color:#408080">CONFIDENTIALITY NOTICE</span></u></p><p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Times New Roman","serif";color:#408080">THIS COMMUNICATION, INCLUDING ANY ATTACHMENT, CONTAINS INFORMATION THAT IS CONFIDENTIAL AND THAT MAY ALSO BE LEGALLY PRIVILEGED, AND IS INTENDED ONLY FOR THE EXCLUSIVE USE OF THE INDIVIDUAL NAMED AS THE RECIPIENT. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT, YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR AND ANY REVIEW, DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION OR ANY ATTACHMENT TO THIS TRANSMISSION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE IMMEDIATELY NOTIFY THE SENDER BY REPLY E-MAIL AND DELETE AND DESTROY ALL COPIES OF THE ORIGINAL MESSAGE. THANK YOU</span><span style="font-size:7.5pt;font-family:"Century Schoolbook","serif";color:#408080">. </span></p>
<p class="MsoNormal"> </p></div>
<font bgcolor="#ffffff" color="#000000"><h5><br><hr>
------------------------------------------------------CONFIDENTIALITY NOTICE ----------------------------------------------------
THIS COMMUNICATION, INCLUDING ANY ATTACHMENT, CONTAINS INFORMATION THAT IS CONFIDENTIAL AND IS INTENDED
ONLY FOR THE EXCLUSIVE USE OF THE INDIVIDUAL NAMED AS THE RECIPIENT. IF THE READER OF THIS MESSAGE IS NOT
THE INTENDED RECIPIENT, YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR AND ANY REVIEW, DISSEMINATION, DISTRIBUTION
OR COPYING OF THIS COMMUNICATION OR ANY ATTACHMENT TO THIS TRANSMISSION IS STRICTLY PROHIBITED.
IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE IMMEDIATELY NOTIFY THE SENDER BY REPLY E-MAIL AND DELETE
AND DESTROY ALL COPIES OF THE ORIGINAL MESSAGE. THANK YOU.
<br><hr></h5></font>
</div><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" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>