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

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

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


Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email As Email,
tblADusers.Office,
'usersm.gif' As icon
From tblADusers
Where (tblADusers.Office Like '') Or
(tblADusers.Office 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