New Report - Memory Chip Type + Available slot

[pasquales]

Hi,

Would be possible to have a report that shows the memory chip type + svailable slots?

Need to upgrade several pc and need to know the memory details in order to purchase the right ones.

Thank a lot.

[Esben_D]

Unfortunately it is not possible to get a report which gives back the amount of available memory slots as Lansweeper does not scan this information. We added this topic to an existing feature request in order to add weight to the feature to scan the amount of memory slots available. You can however use the following report which shows you information about the currently installed memory modules (for Windows assets only).

We added an example report below which gives back the RAM type and the total size of RAM installed.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  TsysMemorytypes.MemoryName,
  Cast(Cast(tblPhysicalMemory.Capacity As BigInt) / 1024 / 1024 As Numeric) As
  [Size in MB]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
  Inner Join TsysMemorytypes On TsysMemorytypes.Memorytype =
    tblPhysicalMemory.MemoryType
Where tblAssetCustom.State = 1