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
