<div>I usually use that link and SQL query analyzer in callmanager. But you need to be sql aware for this. Other might have more ideas.</div>
<div>&nbsp;</div>
<div>Thanks,</div>
<div>&nbsp;</div>
<div>Aman<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 2/12/07, <b class="gmail_sendername">Miller, Steve</b> &lt;<a href="mailto:MillerS@dicksteinshapiro.com">MillerS@dicksteinshapiro.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">What&#39;s the best method for searching the CDR when you are looking for the 911 call(s)???</font></span></div>
<div>&nbsp;</div>
<p align="left"><font face="Arial" color="#0000ff" size="2">Steve Miller<br>Telecom Engineer<br>Dickstein Shapiro LLP<br>1825 Eye Street NW | Washington, DC 20006<br>Tel (202) 420-3370 Fax (202)-330-5607<br></font><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:millers@dicksteinshapiro.com" target="_blank">
<font face="Arial" size="2">millers@dicksteinshapiro.com</font></a><font face="Arial" color="#0000ff" size="2"> </font></p>
<div>&nbsp;</div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">
cisco-voip-bounces@puck.nether.net</a>] <b>On Behalf Of </b>Aman Chugh<br><b>Sent:</b> Monday, February 12, 2007 8:27 PM<br><b>To:</b> Jason Burwell<br><b>Cc:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cisco-voip@puck.nether.net" target="_blank">
cisco-voip@puck.nether.net</a><br><b>Subject:</b> Re: [cisco-voip] Who called 911<br></font><br>&nbsp;</div>
<div><span class="e" id="q_110b8c90729956b5_1">
<div></div>
<div>Hi,</div>
<div>&nbsp;</div>
<div>First thing to check would be is CDR enabled,if yes then you can use this link, it has what you are looking for</div>
<div>&nbsp;</div>
<div><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://cisco.com/en/US/customer/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml" target="_blank">http://cisco.com/en/US/customer/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml
</a></div>
<div>&nbsp;</div>
<div>Thanks,</div>
<div>&nbsp;</div>
<div>Aman<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 2/12/07, <b class="gmail_sendername">Jason Burwell</b> &lt;<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:BurwellJ@firstcharter.com" target="_blank">BurwellJ@firstcharter.com
</a>&gt; wrote:</span> 
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello,</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font>&nbsp;</p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp; 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. 
</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font>&nbsp;</p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am running CCM 4.1(3)es91.</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font>&nbsp;</p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks!</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Jason</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font>&nbsp;</p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Jason T. Burwell</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Infrastructure/Telecommunications</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">First Charter Bank</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">10200 David Taylor Drive</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Charlotte</span></font><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">, NC 28262</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ph-704-688-4664</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">fax-704-688-4901</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.firstcharter.com/" target="_blank">www.firstcharter.com</a></span>
 </font></p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font>&nbsp;</p></div></div>
<div></div><br>_______________________________________________<br>cisco-voip mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net
</a> <br><a onclick="return top.js.OpenExtLink(window,event,this)" 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></span></div>
<p>--------------------------------------------------------<br>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. 
<br><br>To reply to our email administrator directly, send an email to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postmaster@dicksteinshapiro.com" target="_blank">postmaster@dicksteinshapiro.com
</a><br><br>Dickstein Shapiro LLP<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.dicksteinshapiro.com/" target="_blank">http://www.DicksteinShapiro.com</a><br>==============================================================================
<br></p></div></blockquote></div><br>