Forum Discussion

Sajidali125's avatar
Sajidali125
Copper Contributor
Mar 09, 2022
Solved

Missing KBs with Advanced Hunting

Hi Team.  I am looking to use Advance Hunting to get list of Missing KBs on a Devices.    
  • LuizaT's avatar
    LuizaT
    Mar 22, 2022

    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's avatar
LuizaT
Icon for Microsoft rankMicrosoft
Mar 22, 2022

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

 

 

Martinez_Acebo_Luciano's avatar
Martinez_Acebo_Luciano
Copper Contributor
Jul 20, 2023

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?