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 <B0000173049@webserver.netsis.it>
Fri, 18 Sep 1998 23:52:09 +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 za000932 for <emerald@iea-software.com> Fri, 18 Sep 1998 14:26:33 +0100
Received: from [207.53.165.21] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id hhjaaaaa for <emerald@iea-software.com> Fri, 18 Sep 1998 14:26:29 +0100
Message-ID: <3602D152.9C11D90E@iea-software.com>
Date: Fri, 18 Sep 1998 14:32:02 -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: greg@isat.com
CC: emerald@iea-software.com
Subject: Re: SQL Script
References: <000d01bde32f$e4e36dc0$06074dd1@dev.isat.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-ListMember: filippo@netsis.it [emerald@iea-software.com]
Greg Lowthian wrote:
>
> Dale can you send me the script to delete call records for
> users that have been removed from Emerald. I have written one
> but I'm not brave enough (or stupid enough) to run it and want
> to check it against yours.
It would be something like this:
Delete From Calls
Where Not Exists(
Select AccountID From SubAccounts
Where (Username = Login or Username = Shell or Username = email)
}
-- 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