Hardware Reports

[RelientK]

Hello,
I need a hardware report for all computers.

I need:
Manufacture
model
serial number
computer name
computer OS
last login


Thanks,
Nathan

[Hemoco]

try this:

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