Notification

Icon
Error

BIOS Type (Legacy or UEFI) - Report to determine Legacy or UEFI BIOS mode

Posted: Thursday, March 28, 2019 7:01:58 PM(UTC)
manunkind

manunkind

Member Original PosterPosts: 4
2
Like
I've seen this asked around here before but there wasn't a decent report for something like this yet. I had a need today and found where Lansweeper stores this information and how to interpret it.

Code:
Select Top 1000000 tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblDiskPartition.PrimaryPartition,
  tblDiskPartition.BootPartition,
  tblDiskPartition.Bootable,
  tblDiskPartition.Type,
  tblDiskPartition.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblDiskPartition On tblAssets.AssetID = tblDiskPartition.AssetID
Where tblDiskPartition.BootPartition = 'True' And tblAssetCustom.State = 1


"GPT: System" = UEFI Mode
"Installable File System" = Legacy, or BIOS Mode

I spot checked a few of my systems with Powershell and it seems to be accurate.
manunkind
#1manunkind Member Original PosterPosts: 4  
posted: 4/17/2019 8:47:42 PM(UTC)
I guess I could have made this a little cleaner with a Case statement:

Code:
Select Top 1000000 tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblDiskPartition.PrimaryPartition,
  tblDiskPartition.BootPartition,
  tblDiskPartition.Bootable,
  Case
    When tblDiskPartition.Type = 'Installable File System' Then 'BIOS'
    Else 'UEFI'
  End As [BIOS Type],
  tblDiskPartition.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblDiskPartition On tblAssets.AssetID = tblDiskPartition.AssetID
Where tblDiskPartition.BootPartition = 'True' And tblAssetCustom.State = 1

Active Discussions

Lansweeper Windows 7 Assets, their user, and users manager
by  Jeff Hilmo   Go to last post Go to first unread
Last post: Today at 6:51:55 PM(UTC)
Lansweeper Firefox 67 Critical Security Issue
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 11:40:51 AM(UTC)
Report Center BIOS version check
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 1:22:28 PM(UTC)
Lansweeper report in defined period
by  CHIREC  
Go to last post Go to first unread
Last post: Yesterday at 10:46:34 AM(UTC)
Lansweeper Microsoft Patch Tuesday Report - May 2019
by  Hendrik.VE  
Go to last post Go to first unread
Last post: 5/21/2019 8:32:41 AM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D   Go to last post Go to first unread
Last post: 5/21/2019 8:25:30 AM(UTC)
Lansweeper Pc's with SSD
by  Rick I  
Go to last post Go to first unread
Last post: 5/17/2019 6:21:48 PM(UTC)