Skip to content

Instantly share code, notes, and snippets.

@Shivammalaviya
Last active July 18, 2021 11:31
Show Gist options
  • Save Shivammalaviya/b4361767e6330a5e6482f90574efb384 to your computer and use it in GitHub Desktop.
Save Shivammalaviya/b4361767e6330a5e6482f90574efb384 to your computer and use it in GitHub Desktop.
let MSzerodays = dynamic(["CVE-2021-31979",
"CVE-2021-33771",
"CVE-2021-34448"]);
DeviceTvmSoftwareVulnerabilities
|where CveId in (MSzerodays)
|summarize Securitypatches= count(),make_set(CveId) by DeviceName,OSPlatform,KBID=RecommendedSecurityUpdateId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment