‎02-04-2014 06:24 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.Name, web40ProcessorCapacity.MaxClockSpeed,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As varchar) As [Disk Size], Web40OSName.OSname, Web40OSName.SP,
tblComputers.LastknownIP, tblComputers.Username, tblComputers.Userdomain,
tblComputers.Lastseen, tblComputers.Firstseen
From tblComputers Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.Caption Like '%c%'
Order By tblComputers.ComputerUnique
Solved! Go to Solution.
‎02-10-2014 09:58 AM
‎02-10-2014 09:58 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now