The kusto query below will give you a list of all Linux VMs and the extensions they have…
It was handy when the OMI vulnerability was out.
You will get the following info:
VM Name
Operating System
Extensions
Add additional columns to get more info.
Resources | where type == 'microsoft.compute/virtualmachines' | extend JoinID = toupper(id), OSName = tostring(properties.osProfile.computerName), OSType = tostring(properties.storageProfile.osDisk.osType), VMSize = tostring(properties.hardwareProfile.vmSize) | join kind=leftouter( Resources | where type == 'microsoft.compute/virtualmachines/extensions' | extend VMId = toupper(substring(id, 0, indexof(id, '/extensions'))), ExtensionName = name ) on $left.JoinID == $right.VMId | where OSType == 'Linux' | summarize Extensions = make_list(ExtensionName) by OSName, OSType | order by tolower(OSName) asc
The result looks something like this:
Happy resource mining!
References
https://docs.microsoft.com/en-us/azure/governance/resource-graph/samples/advanced?tabs=azure-cli
___________________________________________________________________________________________________
Enjoy!
Regards
blksthl 