cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
manunkind
Engaged Sweeper II
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.

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.
1 REPLY 1
manunkind
Engaged Sweeper II
I guess I could have made this a little cleaner with a Case statement:

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now