Re: [Emerald] Monthly Time

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

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)