Skip to content

Instantly share code, notes, and snippets.

@johnybradshaw

johnybradshaw/Azure_Discovery_Java_and_Oracle.kql

Created June 12, 2023 13:24
Show Gist options
  • Save johnybradshaw/e6dd1e09ae218bdb6d6a13692a1e2aa4 to your computer and use it in GitHub Desktop.
Save johnybradshaw/e6dd1e09ae218bdb6d6a13692a1e2aa4 to your computer and use it in GitHub Desktop.
Download ZIP
An Azure KQL query to discover all VMs that have either Java and/or Oracle installed
Raw
Azure_Discovery_Java_and_Oracle.kql
ConfigurationData
| where ConfigDataType == "Software"
| where SoftwareName contains "Java" or SoftwareName contains "Oracle"
| summarize SoftwareInstalled = strcat(iif(countif(SoftwareName contains "Java") > 0, "Java, ", ""), iif(countif(SoftwareName contains "Oracle") > 0, "Oracle", "")) by Computer
| order by SoftwareInstalled desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment