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.
Quote: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
