Detailed Report

[kevinoie]

Would be really grateful if anyone can help with this report.. I need a report with the following: Computer, Manufacturer, Model, OS, SP, CPU, #Processors, Memory, IP, and Install date. I seem to be missing something in the SQL report builder and cant seem to figure it out.. Would be very very grateful for any assistance..

[kevinoie]

Thats exactly what I need. Thanks a million for your assistance. Much appreciated..

[Hemoco · Accepted solution]

try this:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Computer, Web40OSName.Compimage As icon,
  tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
  As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU,
  web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
  tblComputers.LastknownIP, tblOperatingsystem.InstallDate
From tblComputers Inner Join
  web40CorrectMemory On web40CorrectMemory.Computername =
    tblComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
  tblComputerSystemProduct On tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblOperatingsystem On tblComputers.Computername =
    tblOperatingsystem.Computername Inner Join
  web40ProcessorCapacity On web40ProcessorCapacity.Computername =
    tblComputers.Computername
Order By tblComputers.Computer

[kevinoie]

The problem is not with Lansweeper.. the problem is my lack of Knowledge. I can get most of the fields i need.. Its just the last couple i cant figure out where to find them.. I have been at this for the past 2 days..

[Hemoco]

What exactly is the problem with the report builder?
Do you get a specific error?