Discovered Recently Created Active Directory Users
Discover all active directory users created in the last 7 days within your network. Lansweeper scans the creation date and uses it to generate the overview of all users which have been recently created. This way you can easily see if new employees already have their AD account created or if any AD accounts have been created without your knowledge.
Active Directory Users Created in Last 7 Days Query
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
