11-09-2016 04:18 PM
Select Top 1000000 tblADusers.Username,
tblADusers.Name,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Userdomain,
tblADusers.Displayname,
tblADusers.email As [E-mail],
'usersm.png' As icon,
tblADusers.Lastchanged
From tblADusers
Where tblADusers.email Is Not Null
Order By tblADusers.Username
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now