→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎04-20-2011 05:44 PM
Solved! Go to Solution.
‎04-21-2011 08:37 AM
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
dbo.web40ProcessorCapacity.[total Proc Capacity] As Clockspeed,
web40CorrectMemory.Memory, dbo.tblComputersystem.Manufacturer,
dbo.tblComputersystem.Model, dbo.tblComputers.Lastseen, Web40OSName.Compimage
As icon, web40AllIPLocations.IPLocation
From dbo.tblComputers Inner Join
dbo.web40ProcessorCapacity On dbo.tblComputers.Computername =
dbo.web40ProcessorCapacity.Computername Inner Join
dbo.tblComputersystem On dbo.tblComputers.Computername =
dbo.tblComputersystem.Computername Inner Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
dbo.tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
web40AllIPLocations On web40AllIPLocations.Computername =
dbo.tblComputers.Computername
Where (dbo.web40ProcessorCapacity.[total Proc Capacity] < 1000) Or
(web40CorrectMemory.Memory < 512)
Order By dbo.tblComputers.Computer
‎04-21-2011 04:54 PM
‎04-21-2011 08:37 AM
Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
dbo.web40ProcessorCapacity.[total Proc Capacity] As Clockspeed,
web40CorrectMemory.Memory, dbo.tblComputersystem.Manufacturer,
dbo.tblComputersystem.Model, dbo.tblComputers.Lastseen, Web40OSName.Compimage
As icon, web40AllIPLocations.IPLocation
From dbo.tblComputers Inner Join
dbo.web40ProcessorCapacity On dbo.tblComputers.Computername =
dbo.web40ProcessorCapacity.Computername Inner Join
dbo.tblComputersystem On dbo.tblComputers.Computername =
dbo.tblComputersystem.Computername Inner Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
dbo.tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
web40AllIPLocations On web40AllIPLocations.Computername =
dbo.tblComputers.Computername
Where (dbo.web40ProcessorCapacity.[total Proc Capacity] < 1000) Or
(web40CorrectMemory.Memory < 512)
Order By dbo.tblComputers.Computer
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now