Azure Monitor get free space on VM located in Azure

Question

Hi,

I like to run a Azure log query to get the free space using Perf, but I would like to filter out all Servers/Machines that are not hosted at Azure!

Answer 1

Hi @Anonymous

Welcome to Microsoft Q&A! Thanks for posting the question.

In order to get details of servers/machines not hosted in Azure from Logs, you can use the ComputerEnvironment == 'Non-Azure' column filter on Heartbeat table. The distinct SourceComputerId from the output can be matched against the AgentId or similar column in perf tables to get the metrics only from Non-Azure servers/machine.

Here is a sample:

let nonAzureComputers = Heartbeat | where ComputerEnvironment == 'Non-Azure'  
| distinct SourceComputerId | project pack_array(SourceComputerId);  

InsightsMetrics | where AgentId in~ (nonAzureComputers)  

Please let me know if you have any questions.

---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.