Re: [Emerald] Monthly Time

Dale E. Reed Jr. ( (no email) )
Mon, 16 Aug 1999 10:51:28 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] Yet another SQL problem"
Next message: Dale E. Reed Jr.: "Re: [Emerald] SQL Licensing"
Maybe in reply to: Humberto Guzman: "[Emerald] Monthly Time"

Humberto Guzman wrote:
>
> I am looking for a script that will take all of my "x" account type and show
> me how many hours each account was used on the month...

Try this in isql_w:

Select UserName, Mins=Sum((AcctSessionTime/60)+1)

Previous message: Dale E. Reed Jr.: "Re: [Emerald] Yet another SQL problem"
Next message: Dale E. Reed Jr.: "Re: [Emerald] SQL Licensing"
Maybe in reply to: Humberto Guzman: "[Emerald] Monthly Time"