You may have inactive accounts in Emerald that are no longer
in Mailsite. Also, you are not restricting the first query
to just mailsite users. Other services will be in the list
(ie, no ESID checking).
Dale E. Reed Jr. Emerald and RadiusNT
__________________________________________
IEA Software, Inc. www.iea-software.com
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
> Sent: Wednesday, July 12, 2000 11:05 AM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] Emerald & Mailsite Lists
>
>
> Dale,
>
> If I run the active query:
> Select EMail=Login + '@' + d.MailDomain, FullName=sa.FirstName + ' ' +
> sa.LastName
> From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
> Where ma.CustomerID = sa.CustomerID
> AND ma.Active=1 and sa.Active=1
> AND g.DomainID = d.DomainID
> AND ma.GroupID = g.GroupID
>
> I get a list of the active Email addresses, and when I run the
> inactive query:
> Select EMail=ISNULL(Email, Login + '@' + d.MailDomain),
> FullName=convert(varchar,sa.FirstName + ' ' + sa.LastName)
> From MasterAccounts ma, SubAccounts sa, Groups g, Domains d, AccountTypes
> at1
> Where ma.CustomerID = sa.CustomerID
> AND (ma.Active=0 OR sa.Active=0)
> AND g.DomainID = d.DomainID
> AND ma.GroupID = g.GroupID
> AND at1.AccountType = sa.AccountType
> AND at1.ExternalSystemID = 1
>
> I get a list of inactive email addresses.
> The problem is that the totals of these two should equal(or be
> close to) the number of mailboxes on my mailsite server.
> They are several hundred different. I don't understand why?
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart