Custom Report: Computers Being Dublicated

[ajrmorton]

Hey all I am fairly new to the Lansweeper family and am trying to create a custom report with the following items:

User Name
Asset Tag (AKA Computer Name)
Service Tag (Manufacturer)
Computer Model
CPU Type
Number of Processors
Processor(s) Speed(s)
FSB
Total RAM
Total Hard Drive Size
Free Hard Drive Space
Last IP Address

When we put this report together it is giving each bank by creating seperate lines of the computer. How do we report the following above like all combined?

Is there a list of all the elements within the tables like a reference guide?

[Hemoco · Accepted solution]

We fixed one issue with the report in that web40CorrectMemory was not linked to tblComputers. We also changed the code so that a distinct line is only listed once. The new code can be found below.
However, it is normal to be seeing several lines per machine, since you are reporting on disks as well. Each disk will be a separate line in the report. You can exclude some disks if you wish, but you will always have multiple lines per machine if you are reporting on more than one disk.

Select Distinct Top 1000000 tblComputers.Username As [User],
tblComputers.Computer As [Asset Tag],
tblComputerSystemProduct.IdentifyingNumber As [Service Tag],
tblComputersystem.Model As Model, tblPROCESSOR.Name As CPU,
tblPROCESSOR.MaxClockSpeed As [CPU Speed], tblPROCESSOR.ExtClock As FSB,
web40CorrectMemory.Memory As Memory, tblPhysicalMemory.Speed As
[Memory
Speed], tblDiskdrives.Caption, tblDiskdrives.Size As [HD Size],
tblDiskdrives.Freespace As [HD Free], tblOperatingsystem.Caption As OS,
tblOperatingsystem.CSDVersion As SP
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblPhysicalMemory On tblComputers.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblPhysicalMemoryArray On tblComputers.Computername =
tblPhysicalMemoryArray.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername