‎03-28-2019 07:01 PM
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
‎04-17-2019 09:47 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now