Strange report

[paprita]

I have modified "all portable computer" report and I have create another report called "All obsolete portable computers"; the only difference is memory size set to <= 512.000.000.

Select Top 100 Percent dbo.tblComputers.Computername As Computer,
dbo.tblOperatingsystem.Description, dbo.tblComputerSystemProduct.Vendor,
dbo.tblComputerSystemProduct.Name, dbo.tblComputers.Lastseen As
[Last scanned], dbo.tblComputerSystemProduct.Lastchanged,
tblPhysicalMemory.Capacity
From dbo.tblComputers Left Outer Join
dbo.tblComputerSystemProduct On dbo.tblComputers.Computername =
dbo.tblComputerSystemProduct.Computername Left Outer Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Inner Join
tblPhysicalMemory On dbo.tblComputers.Computername =
tblPhysicalMemory.Computername
Where dbo.tblComputers.Computername In (Select tblportablebattery.Computername
From tblportablebattery) And tblPhysicalMemory.Capacity <= 512000000
Order By dbo.tblComputers.Computername

In the output some PC are reported twice or more, with different memory size (have a look of files in attach) sometimes with ridicolous values ...

What's the matter?

[Hemoco]

You are linking to tblportablebattery.
Do these portables have multiple batteries?

[paprita]

Lansweeper wrote:
You are linking to tblportablebattery.
Do these portables have multiple batteries?

I don't think they have multiply battery but I'll check ... stay tuned ...