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

[sloutsky]

This repo is for KQL parser, and it seems that your question is specific to the data structuring inside Azure Monitor (Log Analytics).