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

Report Center Failed Logins Report/Chart
by  Cindy.C   Go to last post Go to first unread
Last post: Today at 11:05:12 AM(UTC)
Lansweeper Microsoft Patch Tuesday Report - May 2019
by  jase  
Go to last post Go to first unread
Last post: Yesterday at 10:17:06 PM(UTC)
Lansweeper Report of Monitors Connected To PC's
by  meddlema   Go to last post Go to first unread
Last post: Yesterday at 10:04:39 PM(UTC)
Lansweeper Windows 7 Assets, their user, and users manager
by  Jeff Hilmo  
Go to last post Go to first unread
Last post: Yesterday 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: Yesterday at 11:40:51 AM(UTC)
Report Center BIOS version check
by  Esben.D  
Go to last post Go to first unread
Last post: 5/22/2019 1:22:28 PM(UTC)
Lansweeper report in defined period
by  CHIREC   Go to last post Go to first unread
Last post: 5/22/2019 10:46:34 AM(UTC)