cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
antopina
Engaged Sweeper
How do I create a report to identify the RAM memory modules type?
DDR OR DDR2 OR DDR3 inside?

Please support me
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

5 REPLIES 5
MikeMc
Champion Sweeper II
hasayeret,

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

Hemoco
Lansweeper Alumni
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
Engaged Sweeper II
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
Engaged Sweeper II
Can you please update this query for the new Lansweeper DB structure?
Hemoco
Lansweeper Alumni
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