→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
paprita
Champion Sweeper
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?
2 REPLIES 2
Hemoco
Lansweeper Alumni
You are linking to tblportablebattery.
Do these portables have multiple batteries?
paprita
Champion Sweeper
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 ...