Max Bandwidth in memory

[ayrus]

I want to display the report that displays Max Bandwidth in memory, for example PC3-10700H. Thanks

[fjca]

ayrus wrote:
I want to display the report that displays Max Bandwidth in memory, for example PC3-10700H. Thanks

Here, you can use mine:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblBaseBoard.Product,
  Cast(Cast(tblPhysicalMemory.Capacity As BigInt) / 1024 / 1024 As Numeric(8,0))
  As DIMM,
  tblAssets.Memory,
  tblAssets.Lastseen,
  tblPhysicalMemory.MemoryType,
  tblPhysicalMemory.TypeDetail,
  tblPhysicalMemory.Speed,
  tblPhysicalMemory.Manufacturer As Manufacturer1,
  tblPhysicalMemory.PartNumber,
  tblPhysicalMemory.SerialNumber,
  tblBIOS.SMBIOSBIOSVersion
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblBaseBoard On tblAssets.AssetID = tblBaseBoard.AssetID
  Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblAssetCustom.Manufacturer Not Like '%xen%' And
  tblAssetCustom.Manufacturer Not Like '%vmware%' And tblAssetCustom.State = 1

Be aware that this is very low level information (well, for WMI, that is) and that can be missing/wrong/misleading. I have some very weird values on my reports, mainly on OEM/older machines.
Also, the "Speed" column lists the MAXIMUM DIMM bandwidth (per the SPD chip), not the current DIMM speed.

[Esben_D]

All the memory related information (for Windows assets) is stored in tblPhysicalMemory. The maximum memory bandwidth is not stored in a Windows WMI class, however you might be able to calculate it using the clock speed.