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
