Forum Discussion
Azure Monitor Alert for low disk space percent and MB
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 lef...
You can get close with
InsightsMetrics | where Origin == "vm.azm.ms" and Namespace == "LogicalDisk" | where Name in ("FreeSpaceMB", "FreeSpacePercentage") | extend Disk=tostring(todynamic(Tags)["vm.azm.ms/mountId"]) | summarize arg_max(TimeGenerated, Val) by Computer, Name, Disk, _ResourceId | extend Packed = bag_pack(Name, Val) | project TimeGenerated, Computer, Disk, _ResourceId, Packed | summarize Packed = make_bag(Packed) by TimeGenerated, Computer, Disk, _ResourceId | evaluate bag_unpack(Packed) : (TimeGenerated:datetime , Computer:string, Disk:string, _ResourceId:string, FreeSpaceMB:long, FreeSpacePercentage:decimal) | extend DiskSizeGB = ceiling((todecimal(FreeSpaceMB) / (FreeSpacePercentage / todecimal(100))) /1024)
source: kql - How to find both disk size and disk space used in azure - Stack Overflow
Recently the ability to use ARG in a Azure Monitor was added, so you can also use that data - by adding arg('') to the start of a query in the Logs blade. This is a simple example of that, you'd have to find the VM by name and its associated disk to make this usable...
arg('').resources
| where type == "microsoft.compute/disks"
| project properties['diskSizeGB']
