Hello,
The Kusto Query in the blog you referenced is correlating the data about various Performance Counters that should be configured to be collected in the Log Analytics Workspace where you run the Query.
I reviewed the query and assuming that the Query is correct (I have not tested it), the following Performance Counters are needed for the Query to provide all the details:
- ObjectName == "Memory" and CounterName contains "Available MBytes"
- ObjectName == "Processor" and CounterName == "% Processor Time" and InstanceName!="_Total"
- ObjectName == "System" and CounterName == "% Processor Time" --> I believe this is for Linux ?!
- ObjectName == "Memory" and CounterName == "Committed Bytes"
- CounterName == "Free Megabytes" --> I believe this is for Linux ?!
- CounterName == "% Free Space" --> this counter is found in the Logical Disk Object
This means that for you to get values for all columns (properties) returned by this Query, you need first to ensure that the Log Analytics Workspace is configured to collect all the above Performance Counters from the connected Agents.
Details on how to configure this are presented here.
I hope this helps!
BR,
George