KQL Question | Microsoft Azure | Page 1

uneven reef Dec 2, 2022, 5:24 AM

#

I'm trying to query virtual machines and extend their network properties such as tehir ipv4, subnet, etc..

i started with this query but its not working
Resources
| where type =~ 'Microsoft.Compute/virtualMachines'
| extend os = properties.storageProfile.osDisk.osType
| join kind=lefouter (Resource
| where type =~ 'Microsoft.Network/networkinterfaces'
| project ipconfig.properties.privateIPAddress

long gyro Dec 2, 2022, 5:31 AM

#

not sure I'm 100% following what you're doing, but you have too many typos in your query.

Here's a working IP query:

resources
    | where type =~ 'Microsoft.Network/networkinterfaces'
    | mv-expand properties.ipConfigurations```

uneven reef Dec 2, 2022, 5:33 AM

#

long gyro not sure I'm 100% following what you're doing, but you have too many typos in yo...

I don't want JUST the ip info tho i'd also like info about the vm disk type and os as well. how can i combine those into one query

long gyro Dec 2, 2022, 5:35 AM

#

What part of the disk info, there's a ton.

#

OS disk, data disks, etc

uneven reef Dec 2, 2022, 5:43 AM

#

long gyro What part of the disk info, there's a ton.

some important things are :
vm os type
host
subnet
nsg
dns name

etc.

#KQL Question