Re: [Emerald] Time usage

Josh Hillman ( (no email) )
Fri, 23 Jul 1999 14:38:44 -0400

From: talon <talon@virtualight.net>
> Anyone have sql script that will get the username, and # of hours
> used between a certain time frame.. like.. # of hours used
> from July 1st - August 1

Here's one that we use. Obviously, you can modify it quite a bit depending
on what you're wanting to do/see.

Josh

Select Username, Month=DateName(Month, CallDate),
Hours=Sum(convert (real, AcctSessionTime))/3600,
/* "Bytes Downloaded"=Sum(AcctOutputOctets),
"Bytes Uploaded"=Sum(AcctInputOctets), */
AccountType,
LoginLimit