Kusto Query for Pod Level CPU Usage for AKS Cluster in Log Analytics

podCPUUsageKustoQueryLogAnalytics

KubePodInventory
| where ClusterName == "prod-aks-cluster"
| where isnotempty(Computer) // eliminate unscheduled pods
| where PodStatus in ('Running')
| extend podLabels = parse_json (PodLabel)
| where podLabels[0]['app.kubernetes.io/instance'] == "payment-service"
| where Namespace == "payment-ns"
| extend ActualContainerName=tostring(split(ContainerName, '/')[1])
| extend InstanceName=strcat(ClusterId, '/', PodUid, '/', ActualContainerName)
| distinct Name, InstanceName
| join 
  (Perf
  | where ObjectName == 'K8SContainer'
  | where CounterName == "cpuUsageNanoCores") on InstanceName
| project CounterValue, TimeGenerated, Name
| render timechart