→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎11-03-2011 02:12 PM
Solved! Go to Solution.
‎11-03-2011 05:55 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputers.LastknownIP
From tblComputers Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Domainrole > 1
Order By tblComputers.ComputerUnique
‎11-03-2011 05:55 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputers.LastknownIP
From tblComputers Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Domainrole > 1
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now