→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎08-27-2012 06:13 PM
Solved! Go to Solution.
‎08-28-2012 12:06 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.Compimage As icon, tblComputers.Domain, tblComputers.Description,
tblComputers.Username, tblComputers.Userdomain, tblComputerSystemProduct.Name
As Model, tblComputerSystemProduct.Vendor As Manufacturer,
tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP
As [IP Address], tblComputers.Lastseen, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.MaxClockSpeed, web40ProcessorCapacity.NrOfProcessors,
web40ProcessorCapacity.CPU, web40CorrectMemory.Memory,
tblVideoController.VideoProcessor, tblVideoController.DeviceID,
tblerrors.CFGname, tblerrors.ErrorText, tblerrors.Lastchanged
From tblComputers Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Left Outer Join
web40ProcessorCapacity On tblComputers.Computername =
web40ProcessorCapacity.Computername Left Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Left Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where tblComputerSystemProduct.Name <> 'VMware Virtual Platform' And
tblVideoController.DeviceID = 'VideoController1' And tblDiskdrives.Caption =
'c:'
Order By tblComputers.Computername
‎08-28-2012 12:06 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.Compimage As icon, tblComputers.Domain, tblComputers.Description,
tblComputers.Username, tblComputers.Userdomain, tblComputerSystemProduct.Name
As Model, tblComputerSystemProduct.Vendor As Manufacturer,
tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP
As [IP Address], tblComputers.Lastseen, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.MaxClockSpeed, web40ProcessorCapacity.NrOfProcessors,
web40ProcessorCapacity.CPU, web40CorrectMemory.Memory,
tblVideoController.VideoProcessor, tblVideoController.DeviceID,
tblerrors.CFGname, tblerrors.ErrorText, tblerrors.Lastchanged
From tblComputers Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Left Outer Join
web40ProcessorCapacity On tblComputers.Computername =
web40ProcessorCapacity.Computername Left Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Left Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where tblComputerSystemProduct.Name <> 'VMware Virtual Platform' And
tblVideoController.DeviceID = 'VideoController1' And tblDiskdrives.Caption =
'c:'
Order By tblComputers.Computername
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now