Users: AD user attributes (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists users in Active Directory and the attributes that have been scanned by Lansweeper.

Domain users are automatically scanned when they log into a computer during a computer scan. Additional users can also be scanned with Domain User Scanning.

The report will only give back users that meet all of the following criteria:

The user was scanned from Active Directory

Select Top 1000000 tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblADusers.Name,
  tblADusers.Displayname,
  tblADusers.Description,
  tblADusers.Office,
  tblADusers.Telephone,
  tblADusers.Fax,
  tblADusers.Mobile,
  tblADusers.Street,
  tblADusers.City,
  tblADusers.C,
  tblADusers.Zip,
  tblADusers.Country,
  tblADusers.Countrycode,
  tblADusers.UPN,
  tblADusers.Title,
  tblADusers.Department,
  tblADusers.Company,
  tblADusers.email,
  tblADusers.OU,
  tblADusers.Picture,
  tblADusers.HomePhone,
  tblADusers.Pager,
  tblADusers.IpPhone,
  tblADusers.State,
  tblADusers.HomePage,
  tblADusers.HomeDirectory,
  tblADusers.ProfilePath,
  tblADusers.LogonScript,
  tblADusers.whenCreated,
  tblADusers.whenChanged,
  tblADusers.EmployeeID,
  tblADusers.EmployeeNumber,
  tblADusers.EmployeeType,
  tblADusers.Info,
  tblADusers.Division,
  tblADusers.Lastchanged
From tblADusers
Order By tblADusers.Userdomain,
  tblADusers.Username