Re: Analyzing Calls

Dale E. Reed Jr. ( (no email) )
Mon, 21 Jul 1997 10:52:40 -0700

Wayne Jordan wrote:
>
> We are going to change most of rates pretty soon to hourly, which will also
> increase user fees. What I'd like to do is analyze what the aveage monthly
> usage is for each customer then I'd like to clear all of the call history
> out of the database. Does anyone have any idea on how to do this?

I wrote a query somewhere around here to do that. Do you want just the
straight average or average of each user?

"Truncate Table Calls" and/or "truncate table callhistory" should
work.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com