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
