→ 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 title filled in (Built-in)

The report below gives back a list of users in Active directory where the title is missing.

The report will only list users that meet all of the following criteria:
  • User found in Active Directory
  • Title is empty or null


Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email,
tblADusers.Title,
'usersm.gif' As icon
From tblADusers
Where (tblADusers.Title Like '') Or
(tblADusers.Title Is Null)
Order By tblADusers.Userdomain,
tblADusers.Username
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now