Notification

Icon
Error

Windows: Bios Information (Built-in)

Posted: Thursday, November 20, 2014 10:39:17 AM(UTC)
Daniel.B

Daniel.B

Member Original PosterPosts: 1,150
0
Like
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.
Code:
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

Active Discussions

Lansweeper SSH - Keyboard Interactive Authentication
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Today at 7:44:48 PM(UTC)
Lansweeper Are Deleted Dashboard Tabs Retrievable?
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 4:58:48 PM(UTC)
Lansweeper Missing hyperv host details for guest asset LAN-4130
by  Esben.D   Go to last post Go to first unread
Last post: Today at 4:56:30 PM(UTC)
Lansweeper Dell Warranty Lookup - Incorrect Information
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 4:46:38 PM(UTC)
Lansweeper Initial web loading time
by  Brian Fulmer   Go to last post Go to first unread
Last post: Today at 4:18:54 PM(UTC)
Lansweeper Force SNMP?
by  Andreas  
Go to last post Go to first unread
Last post: Today at 12:30:00 PM(UTC)
Lansweeper Network connections Overview Map
by  CoolDood   Go to last post Go to first unread
Last post: Today at 12:19:21 PM(UTC)
Lansweeper Scanning remote networks
by  Xavi  
Go to last post Go to first unread
Last post: Today at 11:30:16 AM(UTC)