[Emerald] Emerald & Mailsite Lists

PowerNet ( (no email) )
Wed, 12 Jul 2000 10:52:41 -0400

Dale,

I am using the following query in Mailsite to generate a list of users=
that are active.

I have more mailboxes in mailsite than this script says is active because=
some are disabled.
I want to see the mailboxes that exist, but are not active so that I can=
delete them.

How would I modify this script to do such a thing?
Also, after running this script, I see the username and domain, but=
occasionally through the list I get an @domain.com without a username.
Any ideas?

Select EMail=3DLogin + '@' + d.MailDomain, FullName=3Dsa.FirstName + ' ' +
sa.LastName