→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎09-06-2010 06:07 PM
Solved! Go to Solution.
‎09-06-2010 08:44 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
tblComputers.LastknownIP, tblOperatingsystem.InstallDate
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
Order By tblComputers.Computer
‎09-07-2010 11:35 AM
‎09-06-2010 08:44 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
tblComputers.LastknownIP, tblOperatingsystem.InstallDate
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
Order By tblComputers.Computer
‎09-06-2010 07:34 PM
‎09-06-2010 06:59 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now