→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎05-07-2018 06:22 AM
‎05-12-2018 03:10 AM
ayrus wrote:
I want to display the report that displays Max Bandwidth in memory, for example PC3-10700H. Thanks
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
‎05-07-2018 10:44 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now