Windows: Bios Information (Built-in)

[Daniel_B]

Old name: Bios: Information (Built-in)

The report below gives back a list of computers with BIOS information.

The report will only list assets that meet all of the following criteria:

• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The BIOS information is available.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.Image As icon,
  tblBIOS.Caption,
  tblBIOS.Manufacturer,
  tblBIOS.SerialNumber As Serial,
  tblBIOS.SMBIOSMajorVersion As [V.Ma],
  tblBIOS.SMBIOSMinorVersion As [V.Mi],
  tblBIOS.Version,
  tblBIOS.Lastchanged
From tblAssets
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName