Microsoft provided guidance on what information to collect from assets if you’re doing a secure boot certificate update in order to get a full overview of possible assets that might require updates and to ensure you can create a representative test sample of devices.
We’ve taken all the details Microsoft suggests and poured them into a single report so that you don’t have to run their suggested PowerShell scripts and do extra work. You can find more information on this use case in Pro Tips 78.
Run the Secure Boot Certificate Updates Asset Overview Audit Now!
Select Top (1000000) tblAssets.AssetID, tblAssets.AssetName, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.Domain, tblAssets.IPAddress, tblOperatingsystem.Caption as [Operating System], tblComputersystem.SystemType as [OS Architecture], tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssetCustom.Serialnumber, tblBIOS.Caption as BIOS, tblBIOS.SMBIOSBIOSVersion as [BIOS Version], tblBIOS.ReleaseDate, tblState.Statename As State, tblAssets.Lastseen As [Last successful scan] From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblState On tblState.State = tblAssetCustom.State inner join tblOperatingsystem on tblOperatingsystem.AssetID = tblassets.AssetID inner join tblComputersystem on tblComputersystem.AssetID = tblassets.AssetID inner join tblBIOS on tblBIOS.AssetID = tblassets.AssetID Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblAssets.Assettype = -1 and tblBIOS.SMBIOSBIOSVersion is not null Order By tblAssets.AssetName
Explore the full platform, free for 14 days.
No credit card required.
