Microsoft Security Tech Accelerator
Dec 06 2023, 07:00 AM - 12:00 PM (PST)
Microsoft Tech Community

Missing KBs with Advanced Hunting

Copper Contributor

Hi Team. 

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



2 Replies
best response confirmed by Sajidali125 (Copper Contributor)

Hi @Sajidali125,


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


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




@LuizaT , Hello, im having trouble with this query because i can see some KBs but not every KBs that the device is missing. for example dsa-2023-175

Do you know how to see all the missing KBs?