How can I get disk data (total size and used size in GB) for multiple Win VMs ?

Question

How can I fetch or extract disk data that includes the total disk size and used disk size based on drive instances (e.g., C: , E: & other drives) across multiple Windows VMs? I don’t need the data in percentage.

I tried the following query, but the results were not as expected and seemed incorrect.

Perf

| where ObjectName == "LogicalDisk" and CounterName == "Free Megabytes"

| summarize TotalDiskSpace_GB = (max(CounterValue) + sum(CounterValue)/1024), UsedDiskSpace_GB = (sum(CounterValue)/1024),Freespace_GB = ((max(CounterValue) + sum(CounterValue))-sum(CounterValue)/1024) by Computer, InstanceName

Answer 1

Try the following

Perf
| where ObjectName == "LogicalDisk" and (CounterName == "Free Megabytes" or CounterName == "Disk Size (MB)")
| summarize 
    TotalDiskSpace_GB = maxif(CounterValue, CounterName == "Disk Size (MB)") / 1024, 
    Freespace_GB = maxif(CounterValue, CounterName == "Free Megabytes") / 1024, 
    UsedDiskSpace_GB = (maxif(CounterValue, CounterName == "Disk Size (MB)") - maxif(CounterValue, CounterName == "Free Megabytes")) / 1024 
  by Computer, InstanceName
| order by Computer, InstanceName asc

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin