Users: AD users created in last 7 days (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists all the domain users that have been created in the last 7 days.
Domain users are automatically scanned when they log into a computer during a computer scan.

Select Top 1000000 tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblADusers.Name,
  tblADusers.Displayname,
  tblADusers.email,
  tblADusers.whenCreated As CreationDate
From tblADusers
Where tblADusers.whenCreated > GetDate() - 7
Order By CreationDate Desc,
  tblADusers.Userdomain,
  tblADusers.Username