→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

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

The report below lists users in Active directory having no department filled in.

Meets all of the following criteria:
  • User found in Active Directory
  • Department empty or null
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email As Email,
tblADusers.Department,
'usersm.gif' As icon
From tblADusers
Where (tblADusers.Department Like '') Or
(tblADusers.Department 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