Missing KBs with Advanced Hunting

[Sajidali125]

Hi Team. 

I am looking to use Advance Hunting to get list of Missing KBs on a Devices.

[#2 · Accepted solution]

Hi @Sajidali125,

This is the simplest one you may use for one device if this is the output you are looking for:

DeviceTvmSoftwareVulnerabilities
| where RecommendedSecurityUpdate contains "security updates" and DeviceName == "ExactDeviceName"
| distinct RecommendedSecurityUpdateId