Re: Analyzing Calls

Wayne Jordan ( )
Mon, 21 Jul 1997 15:52:14 -0500

Average per user

At 10:52 AM 7/21/97 -0700, you wrote:
>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
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List