→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
Old name: Active directory: User has no display name (Built-in)

The report below lists users in Active directory where the display name is missing.

The report will only list users that meet all of the following criteria:
  • User found in Active Directory
  • Display name 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.Displayname Like '') Or
(tblADusers.Displayname Is Null)
Order By tblADusers.Userdomain,
tblADusers.Username
0 REPLIES 0