→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
91Tech
Engaged Sweeper
Can someone point me to where in the tables I could find the highlighted info in the pic provided? Im trying to generate a report with a bunch of RAM info, but the big one I am missing is what type of RAM we need to order for adding in.

Image showing "MemoryName"
1 REPLY 1
Hemoco
Lansweeper Alumni
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysMemorytypes.MemoryName, tblPhysicalMemory.BankLabel,
tblPhysicalMemory.Capacity, tblPhysicalMemory.DataWidth,
tblPhysicalMemory.DeviceLocator
From tblComputers Inner Join
tblPhysicalMemory On tblComputers.Computername =
tblPhysicalMemory.Computername Inner Join
TsysMemorytypes On TsysMemorytypes.Memorytype = tblPhysicalMemory.MemoryType