Forum Discussion

dmarquesgn's avatar
dmarquesgn
Iron Contributor
Dec 22, 2022

Kusto Query get total number of unique CVEs

Hi,

I'm trying to create a Kusto Query to get the total number of unique CVEs viewed by Defender.

I think that is the information that is shown on the "Weaknesses" dashboard, but I would like to extract that in a query, but I'm new to Kusto Query and I'm not understanding how can I do that. Can anyone help me on how to build this query?

Thanks

  • Hi,
    Thank you for reaching out!
    The following query can be used at Advanced hunting:
    ------------------------------------
    DeviceTvmSoftwareVulnerabilities
    | distinct CveId
    | count
    -------------------------------------
  • Hi,
    Thank you for reaching out!
    The following query can be used at Advanced hunting:
    ------------------------------------
    DeviceTvmSoftwareVulnerabilities
    | distinct CveId
    | count
    -------------------------------------

Resources