Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community
SOLVED

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)
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

 

LuizaT_0-1647944649615.png

 

@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?

1 best response

Accepted Solutions
best response confirmed by Sajidali125 (Copper Contributor)
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

 

LuizaT_0-1647944649615.png

 

View solution in original post