Hello,

I am trying to create a KQL query that will alert me if the diskspace percentage exceeds a percentage threshold. But I also want the alert to show how much used space and free space is left in MB.  I have the below query that shows the percentage. How can I get it to show the used space and free space is left in MB?  Thank you.

InsightsMetrics
| where Origin == “vm.azm.ms”
| where Namespace == “LogicalDisk” and Name == “FreeSpacePercentage”
| summarize LogicalDiskSpacePercentageFreeAverage = avg(Val) by bin(TimeGenerated, 15m), Computer, _ResourceId

​Hello, I am trying to create a KQL query that will alert me if the diskspace percentage exceeds a percentage threshold. But I also want the alert to show how much used space and free space is left in MB.  I have the below query that shows the percentage. How can I get it to show the used space and free space is left in MB?  Thank you. InsightsMetrics| where Origin == “vm.azm.ms”| where Namespace == “LogicalDisk” and Name == “FreeSpacePercentage”| summarize LogicalDiskSpacePercentageFreeAverage = avg(Val) by bin(TimeGenerated, 15m), Computer, _ResourceId  Read More

​