cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ayrus
Engaged Sweeper
I want to display the report that displays Max Bandwidth in memory, for example PC3-10700H. Thanks
2 REPLIES 2
fjca
Champion Sweeper II
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
Lansweeper Employee
Lansweeper Employee
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now