Forum Discussion

Sajidali125's avatar
Sajidali125
Copper Contributor
Mar 10, 2022

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?

Resources