Old name: Active directory: User has no telephone filled in (Built-in)
The report below gives back a list of users in Active directory where the telephone number is missing.
The report will only list users that meet all of the following criteria:
- User found in Active Directory
- Telephone is empty or null
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email As Email,
tblADusers.Telephone,
'usersm.gif' As icon
From tblADusers
Where (tblADusers.Telephone Like '') Or
(tblADusers.Telephone Is Null)
Order By tblADusers.Userdomain,
tblADusers.Username
