[cisco-voip] Most Dialed Outgoing Calls

[Mike Armstrong]

However you define "most popular", the ways that come to mind are:

1) Capture the data from the CDR database into either an Access database or 
Excel and have at it
2) Be or become sufficiently skilled in SQL query writing to do it in the 
original

For complex or lengthy analyses, I use (1) for the most part, to avoid tying 
up, and possibly destroying, the CDR database.  I maintain the historic CDR 
data in monthly Access databases for those purposes, but for simply queries 
of current data I use the Query Manager directly.

Mike Armstrong
UF/IFAS CREC
Lake Alfred, FL

> Date: Tue, 13 Feb 2007 07:23:55 -0500
> From: "Miller, Steve" <MillerS at DicksteinShapiro.COM>
> Subject: [cisco-voip] Most Dialed Outgoing Calls???
> To: cisco-voip at puck.nether.net
> Message-ID: <B9B5B75DF9145F44A21111DD92CC490004FFAB76 at DCEX2.DSMO.COM>
> Content-Type: text/plain; charset=us-ascii
>
> There must be a way to see the most popular OUTGOING calls on my system,
> but I can't find it in the CDR.  Please let me know what I am missing.
> Thank you!
>
>
> Steve Miller
> Telecom Engineer
> Dickstein Shapiro LLP
> 1825 Eye Street NW | Washington, DC 20006
> Tel (202) 420-3370 Fax (202)-330-5607
> millers at dicksteinshapiro.com