We are here to serve...<br><br>BTW, thanks for letting us know our solution worked... We want these archives to be searchable and if there is no feedback, people may try things that don't do anything...<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">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">Thank you.......and THANKS ALL to your generous help
today! MUCH appreciated!</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"><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 3:54
PM<br><b>To:</b> Mike Armstrong<br><b>Cc:</b> Miller, Steve;
<a href="mailto:cisco-voip@puck.nether.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cisco-voip@puck.nether.net</a></font><div><span class="e" id="q_110bcecce38ad3fd_3"><font face="Tahoma" size="2">
<br><b>Subject:</b> Re: [cisco-voip] Most Dialed
Outgoing Calls<br></font></span></div><br></div><div><span class="e" id="q_110bcecce38ad3fd_5">
<div></div>If the query says 'USE CDR' it doesn't matter which DB is selected
from the drop down...<br><br>However, it couldn't
hurt...<br><br><br><br>Jonathan<br><br>
<div><span class="gmail_quote">On 2/13/07, <b class="gmail_sendername">Mike
Armstrong</b> <<a href="mailto:mfa@crec.ifas.ufl.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mfa@crec.ifas.ufl.edu</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;">Steve
--<br><br>Once you're in the Query Analyzer, first make sure the CDR database
is<br>selected in the dropdown in the menu bar. Then I usually
select<br>Window->Show Results Pane, so I can enter the query in the upper
pane, and <br>see the results in the lower. Now you're ready to go
-- start simple, use a<br>simple SQL reference of some kind, and build on your
knowledge.<br><br>The simplest query might be something like "SELECT
dateTimeOrigination, <br>callingPartyNumber, finalCalledPartyNumber, duration
FROM CallDetailRecord".<br>This will list all calls in the
database. You can narrow the results by<br>adding a WHERE clause,
order the results with ORDER BY, group, total, etc. <br>A very useful clause
is the TOP n clause, which allows you to only see the<br>top "n" rows of the
result -- i.e., SELECT TOP 20 ... FROM ... etc.<br><br>Click on the blue
checkmark in the menu bar, and the query will be parsed -- <br>very elementary
checking. The result of the parse will show up in the<br>Results
pane. Now fire for effect -- click on the green triangle to
the<br>right of the checkmark, and the query will be executed. BE
VERY CAREFUL not <br>to run very long or complex queries on the production
CallManager.<br><br>I fussed with this for a while, and came up with the
following, which I<br>think will do what you want:<br><br>SELECT TOP 10
originalCalledPartyNumber, Count (originalCalledPartyNumber) <br>AS 'Count'
from CallDetailRecord GROUP BY originalCalledPartyNumber ORDER BY<br>Count
DESC<br><br>Good luck, have fun.<br><br>Mike Armstrong<br>UF/IFAS CREC<br>Lake
Alfred, FL<br><br><br>----- Original Message ----- <br>From: "Miller, Steve"
<<a href="mailto:MillerS@DicksteinShapiro.COM" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MillerS@DicksteinShapiro.COM</a>><br>To:
"Mike Armstrong" <<a href="mailto:mfa@crec.ifas.ufl.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mfa@crec.ifas.ufl.edu </a>><br>Sent:
Tuesday, February 13, 2007 9:43 AM<br>Subject: RE: [cisco-voip] Most Dialed
Outgoing Calls<br><br><br>Thanks. Do you have an example of a query
that could be used and brief<br>step-by-step instructions on what commands to
use once you open the SQL <br>analyzer?<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: Mike Armstrong [mailto:<a href="mailto:mfa@crec.ifas.ufl.edu" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mfa@crec.ifas.ufl.edu</a>]<br>Sent:
Tuesday, February 13, 2007 9:40 AM<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>;
Miller, Steve<br>Subject: Re: [cisco-voip] Most Dialed Outgoing
Calls<br><br>However you define "most popular", the ways that come to mind
are:<br><br>1) Capture the data from the CDR database into either an Access
database <br>or Excel and have at it<br>2) Be or become sufficiently skilled
in SQL query writing to do it in<br>the original<br><br>For complex or lengthy
analyses, I use (1) for the most part, to avoid<br>tying up, and possibly
destroying, the CDR database. I maintain the <br>historic CDR data
in monthly Access databases for those purposes, but<br>for simply queries of
current data I use the Query Manager directly.<br><br>Mike
Armstrong<br>UF/IFAS CREC<br>Lake Alfred, FL<br><br>> Date: Tue, 13 Feb
2007 07:23:55 -0500 <br>> From: "Miller, Steve" <<a href="mailto:MillerS@DicksteinShapiro.COM" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">MillerS@DicksteinShapiro.COM</a>>
<br>>
Subject: [cisco-voip] Most Dialed Outgoing Calls???<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>>
Message-ID: <<a href="mailto:B9B5B75DF9145F44A21111DD92CC490004FFAB76@DCEX2.DSMO.COM" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">B9B5B75DF9145F44A21111DD92CC490004FFAB76@DCEX2.DSMO.COM</a>
><br>>
Content-Type: text/plain; charset=us-ascii <br>><br>> There must be a
way to see the most popular OUTGOING calls on my<br>> system, but I can't
find it in the CDR. Please let me know what I
am<br>missing.<br>> Thank you!<br>><br>><br>> Steve Miller
<br>> Telecom Engineer<br>> Dickstein Shapiro LLP<br>> 1825 Eye
Street NW | Washington, DC 20006 Tel (202) 420-3370 Fax<br>> (202)-330-5607
<a href="mailto:millers@dicksteinshapiro.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">millers@dicksteinshapiro.com
</a><br><br><br><br>--------------------------------------------------------<br>This
e-mail message and any attached files are confidential and are
intended<br>solely for the use of the addressee(s) named above. This
communication may <br>contain material protected by attorney-client, work
product, or other<br>privileges. If you are not the intended recipient or
person responsible for<br>delivering this confidential communication to the
intended recipient, you <br>have received this communication in error, and any
review, use,<br>dissemination, forwarding, printing, copying, or other
distribution of this<br>e-mail message and any attached files is strictly
prohibited. Dickstein <br>Shapiro reserves the right to monitor any
communication that is created,<br>received, or sent on its
network. If you have received this confidential<br>communication in
error, please notify the sender immediately by reply e-mail <br>message and
permanently delete the original message.<br><br>To reply to our email
administrator directly, send an email to<br><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>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>
<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></span></div></div>
</blockquote></div><br>