Lookup vulnerability information based on a CveID
Query · kql
let CVE = "CVE-2022-3602"; // Add your CVEid here DeviceTvmSoftwareVulnerabilities | where CveId == CVE | summarize VulnerableDevices = make_set(DeviceName) by CveId | join kind=innerunique DeviceTvmSoftwareVulnerabilitiesKB on CveId | extend TotalDevices = array_length(VulnerableDevices) | project TotalDevices, CveId, VulnerabilitySeverityLevel, CvssScore, VulnerabilityDescription, VulnerableDevices