Re: Reports showing online time.

Dale E. Reed Jr. ( (no email) )
Tue, 01 Apr 1997 02:16:19 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: David Edwards: "More Services Tab Type Mismatch Error"
Next message: Kelly Wright: "Charges"
Maybe in reply to: J Dyer: "Reports showing online time."

J Dyer wrote:
>
> Hi,
>
> Does anyone have a report that can show total time online (in mins) per calender month by account.
>
> Or a clue as to how to create it with SQL

Just off the top of my head:

Select Username, TheMonth=DatePart(Month, CallDate),
Mins=Sum(AcctSessionTime)/60

Previous message: David Edwards: "More Services Tab Type Mismatch Error"
Next message: Kelly Wright: "Charges"
Maybe in reply to: J Dyer: "Reports showing online time."