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 Trigger deploy when seen
by  bbazian   Go to last post Go to first unread
Last post: Today at 10:31:44 AM(UTC)
Lansweeper More customizable interface
by  Christophe Rahier  
Go to last post Go to first unread
Last post: Today at 9:09:33 AM(UTC)
Lansweeper Update DNS record
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:42:51 AM(UTC)
Lansweeper TeamViewer Custom Action
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 1:39:48 AM(UTC)
Lansweeper Deployment Java
by  mlachance   Go to last post Go to first unread
Last post: Yesterday at 4:46:38 PM(UTC)
Lansweeper Custom OID Scanning Range
by  tcooper  
Go to last post Go to first unread
Last post: Yesterday at 4:32:59 PM(UTC)
Lansweeper Approved Software
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 4:07:58 PM(UTC)
Lansweeper Scanning targets - ignore assets with LSagent
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 4:01:44 PM(UTC)