Users: AD user has no e-mail address

[Nick_VDB]

The report below lists users in Active Directory that have no e-mail address filled in.

The report will only list users that meet all of the following criteria:

• The user was scanned in Active Directory
  
• The user has no e-mail address

Select Top 1000000 tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblADusers.Name,
  tblADusers.Displayname,
  tblADusers.email as Email,
  'usersm.gif' As icon
From tblADusers
Where (tblADusers.email Like '') Or
  (tblADusers.email Is Null)
Order By tblADusers.Userdomain,
  tblADusers.Username