→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

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.