Notification

Icon
Error

Windows: Bios Information (Built-in)

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

Daniel.B

Member Administration 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 How to scan assets on a different network
by  twpseaton   Go to last post Go to first unread
Last post: Yesterday at 10:04:36 PM(UTC)
Lansweeper How do you scan your assets on your network?
by  OycAdmin  
Go to last post Go to first unread
Last post: Yesterday at 8:48:11 PM(UTC)
Lansweeper Lansweeper warnings sent to an email
by  MilicaM   Go to last post Go to first unread
Last post: Yesterday at 2:23:29 PM(UTC)
Lansweeper ShellRunAs action in Lansweeper
by  DavidL  
Go to last post Go to first unread
Last post: Yesterday at 11:58:07 AM(UTC)
Lansweeper Location -> ipLocation Undefined
by  Michaelvds   Go to last post Go to first unread
Last post: Yesterday at 9:58:03 AM(UTC)
Lansweeper Changing/Editing tblComputerSystem.DomainRole
by  Esben.D   Go to last post Go to first unread
Last post: 6/24/2019 2:41:17 PM(UTC)
Lansweeper Version Check Page
by  Esben.D  
Go to last post Go to first unread
Last post: 6/24/2019 2:37:43 PM(UTC)