BIOS Information

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