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.
Click to Open - Active Directory Users Without E-Mail Address Query
Select Top 1000000 tblADusers.Username, tblADusers.Userdomain, tblADusers.Displayname, tblADusers.email As [E-mail], 'usersm.png' As icon, tblADusers.Lastchanged From tblADusers Where (tblADusers.email Like '' Or tblADusers.email Is Null) Order By tblADusers.Username