Undeliverable: Re: Time on

System Administrator ( postmaster@nmt.co.il )
Sun, 20 Sep 1998 03:25:10 +0200

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------ =_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--