‎03-14-2012 03:53 PM
Solved! Go to Solution.
‎03-14-2012 04:55 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Model
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Model Not Like '%Virtual Machine%'
Order By tblComputers.ComputerUnique
‎03-14-2012 05:04 PM
‎03-14-2012 04:55 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Model
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Model Not Like '%Virtual Machine%'
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now