→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-26-2011 11:35 PM
Select Top 1000000 tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate, web40lastlogontop.lastuser, tblComputerSystemProduct.IdentifyingNumber, Web40OSName.OSname, tblComputers.Computer, tblComputersystem.Model, web40allcompstates.Computername, web40allcompstates.Statename From tblComputers Inner Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join web40lastlogontop On web40lastlogontop.Computername = tblComputerSystemProduct.Computername Inner Join Web40OSName On Web40OSName.Computername = web40lastlogontop.Computername Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Inner Join web40allcompstates On web40allcompstates.Computername = Web40OSName.Computername
‎09-27-2011 11:56 AM
Select Top 1000000 tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate,
tblComputerSystemProduct.IdentifyingNumber, Web40OSName.OSname,
tblComputers.Computer, tblComputersystem.Model,
web40allcompstates.Computername, web40allcompstates.Statename,
tblComputers.Userdomain, tblComputers.Username
From tblComputers Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
web40allcompstates On web40allcompstates.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now