In the workbook published yesterday we used one graph for %Used Space from Linux servers, and one graph for %Free Space from Windows servers. But for some scenarios you might want to show disk space from both server types in the same graph. The following query convert Linux %Used Space to %Free Space, so they can be visualized together with %Free Space with data from Windows servers.
Perf | where TimeGenerated between (ago(1d) .. now() ) | where CounterName == "% Used Space" or CounterName == "% Free Space" | where InstanceName != "_Total" | where InstanceName !contains "HarddiskVolume" | extend FreeSpace = iff(CounterName == "% Used Space", 100-CounterValue, CounterValue) | extend localTimestamp = TimeGenerated + 2h | extend description = strcat(Computer, " ", InstanceName) | summarize avg(FreeSpace) by bin(localTimestamp, 10m), description | sort by localTimestamp desc | render timechart
Thanks to Vanessa for good conversation and ideas ðŸ™‚