CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Active Directory Users Without E-Mail Address Audit

Active Directory Users

Find Active Directory Users Without an E-mail Address

List all active directory users in your environment that do not have an email address listed in their active directory information. This audit allows you to identify users who have missing information since Lansweeper scans a wide variety of AD user information.  No need to use PowerShell or Command Line scripts, Lansweeper scans AD information without the need of any scripts of agents. Run the audit below and start taking action instantly.

Active directory User has no e-mail address

Active Directory Users Without E-Mail Address Query

Select Top 1000000 Case
    When tblADusers.Displayname Is Null Or
      tblADusers.Displayname = '' Then tblADusers.Userdomain + '\' +
      tblADusers.Username
    Else tblADusers.Displayname
  End As Displayname,
  tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.email As [E-mail],
  'usersm.png' As icon,
  tblADusers.IsEnabled As EnabledInAD,
  tblADusers.Lastchanged
From tblADusers
Where (tblADusers.email Like '' Or tblADusers.email Is Null)
Order By Displayname

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.