 Rank: Administration Groups: Administration, Premium Users
Posts: 9,982
|
try this: Code:Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
Web40OSName.Compimage As icon, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name As Model,
tblComputerSystemProduct.IdentifyingNumber As Serial,
dbo.tblComputers.Lastseen
From dbo.tblComputers Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
tblComputerSystemProduct On dbo.tblComputers.Computername =
tblComputerSystemProduct.Computername
Order By dbo.tblComputers.Computer
|
