Jetzt Ausprobieren

Motherboard Information

Hardware Hardware Components

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

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

Show

Hide