Skip to content

Instantly share code, notes, and snippets.

@JordanTheITGuy

JordanTheITGuy/ProjectVulnerabilities.KQL

Created September 2, 2021 16:59
Show Gist options
  • Save JordanTheITGuy/a86d3eb687d01c0b28d1384be1a2a8a5 to your computer and use it in GitHub Desktop.
Save JordanTheITGuy/a86d3eb687d01c0b28d1384be1a2a8a5 to your computer and use it in GitHub Desktop.
Download ZIP
Merge Device Vulnerability Data with uh
Raw
ProjectVulnerabilities.KQL
DeviceTvmSoftwareVulnerabilities
| join DeviceInfo on DeviceId, $left.DeviceId == $right.DeviceId
| project DeviceName,OSPlatform,OSVersion,OSArchitecture,SoftwareName,SoftwareVendor,SoftwareVersion,CveId,RecommendedSecurityUpdate,RecommendedSecurityUpdateId,LoggedOnUsers
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment