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 Pushing Packages in Multi-Domain Trusted Environment
by  SPedraza   Go to last post Go to first unread
Last post: Yesterday at 5:43:05 PM(UTC)
Lansweeper Lansweeper Not Saving New Asset
by  Terry1337  
Go to last post Go to first unread
Last post: Yesterday at 3:52:51 PM(UTC)
Lansweeper Email configuration
by  Ian.Prentice   Go to last post Go to first unread
Last post: Yesterday at 3:14:04 PM(UTC)
Lansweeper InTune Scanning not showing all devices
by  TBRIT  
Go to last post Go to first unread
Last post: Yesterday at 3:12:03 PM(UTC)
Lansweeper Unique Custom Fields
by  Hendrik.VE   Go to last post Go to first unread
Last post: Yesterday at 11:52:35 AM(UTC)
Lansweeper Uptime incorrect
by  alfiet  
Go to last post Go to first unread
Last post: Yesterday at 10:53:33 AM(UTC)
Lansweeper Lansweeper Remote Screenshot Folder
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 10:24:31 AM(UTC)
Lansweeper Lansweeper Enterprise optional?
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 10:00:22 AM(UTC)