Use Windows authentication....<br><br>Then:<br><br>use cdr<br>SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber,<br>originalCalledPartyNumber, duration<br>FROM CallDetailRecord<br>ORDER by finalCalledPartyNumber
<br><br>and hit the green triangle...<br><br><br>Jonathan<br><br><br><br><div><span class="gmail_quote">On 2/13/07, <b class="gmail_sendername">Miller, Steve</b> <<a href="mailto:MillerS@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
MillerS@dicksteinshapiro.com</a>> wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">In the SQL server window, should I connect using window
authentication or SQL server authentication?</font></span></div><span>
<div><font color="#0000ff" face="Arial" size="2"></font> </div>
<p align="left"><font color="#0000ff" face="Arial" 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 href="mailto:millers@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><font face="Arial" size="2">millers@dicksteinshapiro.com
</font></a><font color="#0000ff" face="Arial" size="2"> </font></p>
<div> </div><br>
</span><div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Jonathan Charles
[mailto:<a href="mailto:jonvoip@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jonvoip@gmail.com</a>] <br><b>Sent:</b> Tuesday, February 13, 2007 8:46
AM<br><b>To:</b> Miller, Steve<br><b>Cc:</b>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><b>Subject:</b> Re: [cisco-voip] Most Dialed
Outgoing Calls???<br></font><br></div><div><span>
<div></div>Well, you could do a SQL query to the CDR database and then sort by
called number, export to a csv and check...<br><br><br><br>Jonathan<br><br>
<div><span class="gmail_quote">On 2/13/07, <b class="gmail_sendername">Miller, Steve
</b><<a href="mailto:MillerS@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MillerS@dicksteinshapiro.com</a>>
wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">There
must be a way to see the most popular OUTGOING calls on my system,<br>but I
can't find it in the CDR. Please let me know what I am
missing.<br>Thank you!<br><br><br>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><a href="mailto:millers@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">millers@dicksteinshapiro.com</a><br><br><br>-----Original
Message-----<br>From: <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip-bounces@puck.nether.net</a><br>[mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
cisco-voip-bounces@puck.nether.net</a>]
On Behalf Of Erick Bergquist<br>Sent: Tuesday, February 13, 2007 12:08
AM<br>To: Jason Burwell; <a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br>Subject:
Re: [cisco-voip] Who called 911<br><br>You can use CDR Tools And Analysis web
page and do a CDR Search for 911<br>or 9911, that searches called and calling
party numbers but only <br>displays 100 records.<br><br>Or this SQL Query,
replace 911 with 9911 if you use that or
combine<br>them.<br><br>USE<br>CDR<br>SELECT
callingPartyNumber,originalCalledPartyNumber,<br>finalCalledPartyNumber,
duration<br><br>FROM CallDetailRecord<br><br>WHERE
(((originalCalledPartyNumber)="911"))<br><br>----- Original Message
----<br><br><br>From: Jason Burwell <<a href="mailto:BurwellJ@firstcharter.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">BurwellJ@firstcharter.com
</a>><br><br>To: <a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><br>Sent:
Monday, February 12, 2007 3:20:11 PM<br><br>Subject: [cisco-voip] Who called
911<br><br><br><br>
<!-- /* Style Definitions */ <br>p.MsoNormal,
li.MsoNormal,
div.MsoNormal {margin:0in;<br>margin-bottom:.0001pt;
font-size:12.0pt; font-family:"Times New Roman";}<br>a:link,
span.MsoHyperlink {color:blue;
text-decoration:underline;} <br>a:visited,
span.MsoHyperlinkFollowed {color:purple;<br>text-decoration:underline;}
span.EmailStyle17 {
font-family:Arial;<br>color:windowtext;} _filtered { margin:1.0in
1.25in 1.0in 1.25in;}<br>div.Section1 {}
-->
Hello, <br><br><br><br> Can
someone remind me how to find what user dialed 911 in
the<br>system? If I recall this information is on the Publisher somewhere
in<br>SQL.<br><br><br><br> I am running CCM
4.1(3)es91.<br><br><br><br>
Thanks!<br><br>
Jason<br><br><br><br> Jason T.
Burwell<br><br>
Infrastructure/Telecommunications<br><br> First
Charter Bank<br><br> 10200
David Taylor Drive<br><br>
Charlotte, NC 28262 <br><br>
ph-704-688-4664<br><br>
fax-704-688-4901<br><br> <a href="http://www.firstcharter.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.firstcharter.com</a><br><br><br><br><br><br> _______________________________________________
<br><br>cisco-voip
mailing list <br><br><a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>________________________________________________________________________<br>____________<br>Sucker-punch
spam with award-winning protection.<br>Try the free Yahoo! Mail Beta.<br><a href="http://advision.webevents.yahoo.com/mailbeta/features_spam.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://advision.webevents.yahoo.com/mailbeta/features_spam.html</a><br><br>_______________________________________________<br>cisco-voip
mailing list <br><a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br><br>--------------------------------------------------------
<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 href="mailto:postmaster@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postmaster@dicksteinshapiro.com</a><br>
<br>Dickstein
Shapiro LLP<br><a href="http://www.DicksteinShapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.DicksteinShapiro.com</a><br>==============================================================================
<br><br><br>_______________________________________________<br>cisco-voip
mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></blockquote></div><br>
</span></div><p>--------------------------------------------------------<span><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 href="mailto:postmaster@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postmaster@dicksteinshapiro.com</a><br>
<br>
Dickstein Shapiro LLP<br>
<a href="http://www.DicksteinShapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.DicksteinShapiro.com</a><br>
==============================================================================<br>
</span></p></div>
</blockquote></div><br>