First off, don't go into SQL...<br><br>You need to open SQL Query Analyzer... after logging in (Windows Auth), then paste the script into the box and hit the play button...<br><br>Be advised, you are connecting directly to the SQL database... if you do an insert or delete, you are modifying the CCM and CDR live DB... be careful.
<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">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">Exactly. Then, how exactly do I type that
script? I'm sorry to be so needy, but I'm having a hard time figuring our
how to use the instructions.</font></span></div><span class="q">
<div> </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"><span class="q"><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></span><b>Sent:</b> Tuesday, February 13, 2007 1:02
PM<br><b>To:</b> Miller, Steve<br><b>Subject:</b> Re: Do I hit "change database"
when I open up the SQL analyzer?<br></font><br></div><div><span class="e" id="q_110bc5596637f7e0_5">
<div></div>I have never seen that before...<br><br>You do need to use
the:<br><br>use cdr<br><br>to tell it which DB to query... or you can select it
from the dropdown.<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;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Do I hit
"change database" when I open up the SQL analyzer?</font></span></div>
<div> </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>
<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 10:13 AM<br><b>To:</b> Miller,
Steve<br><b>Cc:</b> Cisco Voip<br><b>Subject:</b> Re: [cisco-voip] Most Dialed
Outgoing Calls???<br></font><br></div>
<div></div>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>
<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 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></p></div></blockquote></div><br>
</span></div><p>--------------------------------------------------------<span class="q"><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>