May 27 2020
- last edited on
Apr 08 2022
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?
May 28 2020 01:05 PM
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)