Azure Log Analytics, getting computer details

Question

Hi,

I wanted to get the performance report of my azure VMs using log analytics. I found a blog here

which shows what I wanted.

The problem is when I run the code in my log analytics, it gives all the details except FreeMemoryGB and TotalMemoryGB as shown in the screenshot in the blog. It just shows blank space.

Thanks

Answer 1

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