Forum Discussion

PrashantM2495's avatar
PrashantM2495
Copper Contributor
May 27, 2020

How to find/query disk growth for Windows VM

Hi,

I have to calculate Disk "% Growth" for Windows & Linux VMs.

 

By referring earlier articles/Conversation, I am able to get details/data for Free_Space & Used_Space. Now I have to write a query for "% Growth" and "Growth % ABS".

 

Is any available counter or way to write Log query?  

azure monitor
Log Analytics

2 Replies

  • CliveWatson's avatar
    CliveWatson
    Former Employee
    May 28, 2020

    PrashantM2495 

     

    Are you looking for % change per day?  

    Perf
| where TimeGenerated > startofday(ago(7d))
| where Computer == "VM01"
| where CounterName == "Free Megabytes" and InstanceName == "_Total" 
| summarize max(CounterValue) by Computer, bin(TimeGenerated, 1d)
| order by Computer asc, TimeGenerated asc
| extend changeInMb = max_CounterValue  - prev(max_CounterValue, 1)
| extend pctChange = (changeInMb * 100) / prev(max_CounterValue,1)

Resources