Re: Time on

Dale E. Reed Jr. ( (no email) )
Sat, 19 Sep 1998 18:11:05 -0700

Kevin wrote:
> When I want to check a service with the time on tab on emerald I get no
> results. The SQL is as follows
> Select Start=DateAdd(Second, 0-AcctSessionTime, CallDate),
> (AcctSessionTime/60)+1, (AcctInputOctets/1000)+1, (AcctOutputOctets/1000)+1,
> Location, UserName, AcctTerminateCause, Server, NASPort From Calls, Servers
> Where (Username='pmoser') and CallDate >=
> I see it is missing the date chunk.
> Is this normal?

Where did you get the SQL Statement from? Enterprise Manager only
shows the first part of it. There is several lines from the where clause
missing. Check out the example in the /contrib area, as they should
the full SQL Statements.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |