<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I am not an sql guy.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=aman.chugh@gmail.com href="mailto:aman.chugh@gmail.com">Aman
Chugh</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=MillerS@dicksteinshapiro.com
href="mailto:MillerS@dicksteinshapiro.com">Miller, Steve</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> ; <A
title=BurwellJ@firstcharter.com href="mailto:BurwellJ@firstcharter.com">Jason
Burwell</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, February 12, 2007 8:56
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] Who called
911</DIV>
<DIV><BR></DIV>
<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> </DIV>
<DIV>Thanks,</DIV>
<DIV> </DIV>
<DIV>Aman<BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 2/12/07, <B class=gmail_sendername>Miller,
Steve</B> <<A
href="mailto:MillerS@dicksteinshapiro.com">MillerS@dicksteinshapiro.com</A>>
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's
the best method for searching the CDR when you are looking for the 911
call(s)???</FONT></SPAN></DIV>
<DIV> </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> </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> </DIV>
<DIV><SPAN class=e id=q_110b8c90729956b5_1>
<DIV></DIV>
<DIV>Hi,</DIV>
<DIV> </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> </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> </DIV>
<DIV>Thanks,</DIV>
<DIV> </DIV>
<DIV>Aman<BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 2/12/07, <B class=gmail_sendername>Jason
Burwell</B> <<A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:BurwellJ@firstcharter.com"
target=_blank>BurwellJ@firstcharter.com </A>> 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 link="blue" vlink="purple">
<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> </P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 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> </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> </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> </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> </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>
<P>
<HR>
<P></P>_______________________________________________<BR>cisco-voip mailing
list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip<BR></BLOCKQUOTE></BODY></HTML>