→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
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
0 REPLIES 0