------ =_NextPart_000_01BDE34E.6CF11E9C
Content-Type: text/plain
Your message
To: greg@isat.com
Cc: emerald@iea-software.com
Subject: Re: SQL Script
Sent: Fri, 18 Sep 1998 23:32:02 +0200
did not reach the following recipient(s):
Emerald-list@mail.extent.com on Fri, 18 Sep 1998 23:50:54 +0200
The recipient name is not recognized
MSEXCH:IMS:NMT:nmt:MAIN 0 (000C05A6) Unknown Recipient
------ =_NextPart_000_01BDE34E.6CF11E9C
Content-Type: message/rfc822
Message-ID: <3602D152.9C11D90E@iea-software.com>
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: greg@isat.com
Cc: emerald@iea-software.com
Subject: Re: SQL Script
Date: Fri, 18 Sep 1998 23:32:02 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.1960.3)
X-MS-Embedded-Report:
Content-Type: text/plain
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------ =_NextPart_000_01BDE34E.6CF11E9C--