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">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">MillerS@DicksteinShapiro.COM</a>><br>To: "Mike Armstrong" <<a href="mailto:mfa@crec.ifas.ufl.edu">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">millers@dicksteinshapiro.com
</a><br><br><br>-----Original Message-----<br>From: Mike Armstrong [mailto:<a href="mailto:mfa@crec.ifas.ufl.edu">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">
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">MillerS@DicksteinShapiro.COM</a>><br>> Subject: [cisco-voip] Most Dialed Outgoing Calls???<br>> To: <a href="mailto:cisco-voip@puck.nether.net">
cisco-voip@puck.nether.net</a><br>> Message-ID: <<a href="mailto:B9B5B75DF9145F44A21111DD92CC490004FFAB76@DCEX2.DSMO.COM">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">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">postmaster@dicksteinshapiro.com</a><br><br>
Dickstein Shapiro LLP<br><a href="http://www.DicksteinShapiro.com">http://www.DicksteinShapiro.com</a><br>==============================================================================<br><br>_______________________________________________
<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip
</a><br></blockquote></div><br>