SOLVED

Kusto Query get total number of unique CVEs

Frequent Contributor

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 Replies
best response confirmed by dmarquesgn (Frequent Contributor)
Solution
Hi,
Thank you for reaching out!
The following query can be used at Advanced hunting:
------------------------------------
DeviceTvmSoftwareVulnerabilities
| distinct CveId
| count
-------------------------------------

@Asaf_Wiener 

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