Find Motherboard Information from All Computers in Your Network
Discover all the motherboards in your environment along with detailed information like serial number and version. Lansweeper will automatically retrieve motherboard information from a Windows asset during a scan. Along with basic information from the device like name and operating system details. This report will also show the manufacturer of the motherboard, the product name and most importantly, the serial number and version. Finding these details can often be a very tedious task but with this report you can get a complete overview of your environment in seconds.
Baseboard Information Query
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblBaseBoard.Manufacturer,
tblBaseBoard.Product,
tblBaseBoard.SerialNumber,
tblBaseBoard.Version,
tblBaseBoard.Lastchanged,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBoard.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
