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