‎12-07-2010 07:21 PM
Solved! Go to Solution.
‎12-07-2010 08:15 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username,
tblADusers.Displayname, tblADusers.email, tblComputers.OScode, tsysOS.OSname
From tblComputers Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain Inner Join
tsysOS On tsysOS.OScode = tblComputers.OScode
Where tsysOS.OSname = 'Win 7'
‎12-07-2010 08:52 PM
‎12-07-2010 08:15 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Userdomain, tblComputers.Username,
tblADusers.Displayname, tblADusers.email, tblComputers.OScode, tsysOS.OSname
From tblComputers Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain Inner Join
tsysOS On tsysOS.OScode = tblComputers.OScode
Where tsysOS.OSname = 'Win 7'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now