Useful Kusto/ Azure Resource Graph queries

Going to maintain a running post of userful Azure Resource Graph queries for my own reference.

Getting a list of all VMs created in the last 15 days

Subnets and Address Prefixes

This gives a list of subnets and address prefixes.

This adds the vnet name too, to the subnet.

This gives me subscription Id too.

Public IPs

This gives me public IPs and what it is assigned to.

The output needs some work. ipConfig is currently /subscriptions/<subscriptionId>/resourceGroups/<resourceGroupName>/providers/Microsoft.Network/networkInterfaces/<nic>/ipConfigurations/ipconfig1. I should split or do other things with it.