Users: AD user has no email address

[Bart_M]

The report below lists AD users that do not have an email address associate to them.

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

• User is scanned from Active Directory
  
• Email field is empty or null
  

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