05-23-2012 04:53 PM
05-23-2012 06:32 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblOperatingsystem.InstallDate, tblADusers.Displayname,
tblComputers.Userdomain
From tblComputers Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain Inner Join
web40ActiveComputers On web40ActiveComputers.Computername =
tblComputers.Computername
Order By tblComputers.ComputerUnique
05-23-2012 06:22 PM
05-23-2012 06:03 PM
05-23-2012 04:59 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblOperatingsystem.InstallDate, tblComputers.Username, tblComputers.Userdomain
From tblComputers Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now