Kusto Query for Plotting Pod CPU consumption in Grafana for Azure Kubernetes Service and Log Analytics

cpuKustoQueryForGrafanaAKSLogAnalytics

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'] == "payments-service"
| where Namespace == "payment-ns"
| where $__timeFilter(TimeGenerated)
| extend ActualContainerName=tostring(split(ContainerName, '/')[1])
| extend InstanceName=strcat(ClusterId, '/', PodUid, '/', ActualContainerName) 
| summarize by bin(TimeGenerated, 1m),InstanceName, Name
| join (
 Perf
| where ObjectName == 'K8SContainer'
| where CounterName == 'cpuUsageNanoCores'
| where $__timeFilter(TimeGenerated)
| summarize UsageValue = avg(CounterValue) by bin(TimeGenerated, 5m),InstanceName, CounterName
| project-away CounterName
) on InstanceName,TimeGenerated
| summarize TotalCpuConsumedCores = avg(UsageValue/1000000) by bin(TimeGenerated,5m), Name
| order by TimeGenerated asc