User not known
Your message reads (in part):
Received: from walnut.iea-software.com (unverified [207.53.165.8]) by webserver.netsis.it
(EMWAC SMTPRS 0.83) with SMTP id <B0000173602@webserver.netsis.it>
Sun, 20 Sep 1998 03:27:53 +0200
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000983 for <emerald@iea-software.com> Sat, 19 Sep 1998 18:05:36 +0100
Received: from [207.53.173.26] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id hvjaaaaa for <emerald@iea-software.com> Sat, 19 Sep 1998 18:05:31 +0100
Message-ID: <36045629.4439589F@iea-software.com>
Date: Sat, 19 Sep 1998 18:11:05 -0700
From: "Dale E. Reed Jr." <daler@iea-software.com>
Organization: IEA Software, Inc.
X-Mailer: Mozilla 4.06 [en] (WinNT; I)
MIME-Version: 1.0
To: Kevin <kevin@dilhard.com.ar>
CC: Emerald Lista <emerald@iea-software.com>
Subject: Re: Time on
References: <000001bde428$abddb360$620c20c8@KEVIN>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-ListMember: filippo@netsis.it [emerald@iea-software.com]
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