Kusto Query get total number of unique CVEs

[dmarquesgn]

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

[#2 · Accepted solution]

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

[#3]

@Asaf_Wiener 

Thank you very much. That was exactly what I was searching for.