------ =_NextPart_000_01BDE435.82055D92
Content-Type: text/plain
Your message
To: Kevin
Cc: Emerald Lista
Subject: Re: Time on
Sent: Sun, 20 Sep 1998 03:11:05 +0200
did not reach the following recipient(s):
Emerald-list@mail.extent.com on Sun, 20 Sep 1998 03:25:06 +0200
The recipient name is not recognized
MSEXCH:IMS:NMT:nmt:MAIN 0 (000C05A6) Unknown Recipient
------ =_NextPart_000_01BDE435.82055D92
Content-Type: message/rfc822
Message-ID: <36045629.4439589F@iea-software.com>
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: Kevin <kevin@dilhard.com.ar>
Cc: Emerald Lista <emerald@iea-software.com>
Subject: Re: Time on
Date: Sun, 20 Sep 1998 03:11:05 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.1960.3)
X-MS-Embedded-Report:
Content-Type: text/plain
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
have
the full SQL Statements.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com------ =_NextPart_000_01BDE435.82055D92--