Active Directory Users Without E-Mail Address Audit

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 Users Without E-Mail Address Query

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

Audit and Take Action in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting