RAM memory modules type

[antopina]

How do I create a report to identify the RAM memory modules type?
DDR OR DDR2 OR DDR3 inside?

Please support me

[MikeMc]

hasayeret,

I am not having any problems running the last query provided the support staff. What needs to be updated?

[Hemoco · Accepted solution]

Please use the following report:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Memory / 1024 As 'memory',
tblPhysicalMemory.Speed,
TsysMemorytypes.MemoryName
From tblAssets
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
Inner Join TsysMemorytypes On tblPhysicalMemory.MemoryType =
TsysMemorytypes.Memorytype

[hasayeret]

Lansweeper wrote:
Please use the following report:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Memory / 1024 As 'memory',
tblPhysicalMemory.Speed,
TsysMemorytypes.MemoryName
From tblAssets
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
Inner Join TsysMemorytypes On tblPhysicalMemory.MemoryType =
TsysMemorytypes.Memorytype

Any chance you guys can post an update for this one please?

Thanks!!!

[wgknowles]

Can you please update this query for the new Lansweeper DB structure?

[Hemoco]

Select Distinct Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, web40CorrectMemory.Memory, TsysMemorytypes.MemoryName From tblComputers Inner Join tblPhysicalMemory On tblComputers.Computername = tblPhysicalMemory.Computername Inner Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner Join TsysMemorytypes On tblPhysicalMemory.MemoryType = TsysMemorytypes.Memorytype