How to get the Node Level CPU and Memory Metrics of each pod using KQL Query in Log Analytics Workspace?

[HariKrishna598]

I have tried below kql queries but its not giving the CPU and Memory Metrics of the node described along with the pod details.a

ContainerInventory

| where Computer contains "aks-nodepool1-pvmss000002"

Perf

| where Computer contains "aks-agentpool-vmss000003"

KubeNodeInventory

| where Computer contains "aks-agentpool-vmss000003"

InsightsMetrics

| where Computer contains "aks-agentpool-vmss000003"

but do we have the kubectl queries to get the CPU and Memory Metrics of each nodes- kubectl describe node aks-agentpool-vmss000003

[EvertonSA]

this might help https://learn.microsoft.com/nl-nl/azure/azure-monitor/containers/container-insights-log-query