Forum Discussion
dmarquesgn
Dec 22, 2022Iron Contributor
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
-------------------------------------
- Asaf_Wiener
Microsoft
Hi,
Thank you for reaching out!
The following query can be used at Advanced hunting:
------------------------------------
DeviceTvmSoftwareVulnerabilities
| distinct CveId
| count
-------------------------------------- dmarquesgnIron Contributor
Thank you very much. That was exactly what I was searching for.