CPU usage for last month April 10, 2025 by admin

This provides min max and average

Perf
| where ObjectName == "Processor"
| where CounterName == "% Processor Time"
| where InstanceName == "_Total" or InstanceName == "total"
| where TimeGenerated between (startofmonth(datetime_add("month", -1, now())) .. endofmonth(datetime_add("month", -1, now())))
| extend Month = format_datetime(TimeGenerated, "yyyy-MM")
| summarize 
    MinFreeSpace = min(CounterValue),
    MaxFreeSpace = max(CounterValue),
    AvgFreeSpace = avg(CounterValue)
    by Computer, "% Processor Time", Month