[cisco-voip] Most Dialed Outgoing Calls???

[Mark D. Nagel]

Jonathan Charles wrote:
> Use Windows authentication....
>
> Then:
>
> use cdr
> SELECT dateTimeOrigination, callingPartyNumber, finalCalledPartyNumber,
> originalCalledPartyNumber, duration
> FROM CallDetailRecord
> ORDER by finalCalledPartyNumber
>
> and hit the green triangle...
If you wanted to find called numbers by popularity, wouldn't this query 
be more appropriate?

SELECT count(*) as count, finalCalledPartyNumber
FROM CallDetailRecord
GROUP BY finalCalledPartyNumber
ORDER by count DESC

You might also want to throw in a check for dateTimeOrigination in the 
where clause to bracket the interval you care about.

Regards,
Mark

-- 
Mark D. Nagel, CCIE #3177 <mnagel at willingminds.com>
Principal Consultant, Willing Minds LLC (http://www.willingminds.com)
cell: 949-279-5817, desk: 714-630-4772, fax: 949-623-9854