‎08-15-2011 03:39 PM
Solved! Go to Solution.
‎08-15-2011 10:54 PM
Select Top 1000000 tblComputers.Computer, tblComputerSystemProduct.Vendor As
Manufacturer, tblComputerSystemProduct.Name As Model,
TsysChassisTypes.ChassisName, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors,
web40CorrectMemory.Memory, tblComputers.LastknownIP,
tblOperatingsystem.InstallDate, tblComputers.Username, tblComputers.Lastseen,
tblADusers.Department
From tblComputers Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblComputers.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Order By tblComputers.Computer
‎08-16-2011 01:48 PM
‎08-15-2011 10:54 PM
Select Top 1000000 tblComputers.Computer, tblComputerSystemProduct.Vendor As
Manufacturer, tblComputerSystemProduct.Name As Model,
TsysChassisTypes.ChassisName, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.CPU, web40ProcessorCapacity.NrOfProcessors,
web40CorrectMemory.Memory, tblComputers.LastknownIP,
tblOperatingsystem.InstallDate, tblComputers.Username, tblComputers.Lastseen,
tblADusers.Department
From tblComputers Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Inner Join
tblSystemEnclosure On tblSystemEnclosure.Computername =
tblComputers.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Order By tblComputers.Computer
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now