
This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage.



# Logical disk space % below threshold
let _minValue = 20;
Perf
| where ObjectName == "LogicalDisk" and CounterName == "% Free Space" and InstanceName != "_Total" and InstanceName != "HarddiskVolume1" and InstanceName != "HarddiskVolume2"
| where TimeGenerated >= ago(5m)
| where CounterValue <= _minValue
| summarize arg_max(TimeGenerated, *)by InstanceName
| project Computer, InstanceName, CounterName, CounterValue







ARM - Template:
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"vm_name": {
"type": "String"
},
"location": {
"type": "string",
"defaultValue": "[resourceGroup().location]",
"metadata": {
"description": "Location of the virtual machine"
}
},
"alertSeverity": {
"type": "int",
"defaultValue": 3,
"allowedValues": [
0,
1,
2,
3,
4
]
}
},
"variables": {
"actiongroup_mail_externalid_var": "[concat('/subscriptions/',subscription().subscriptionId,'/resourceGroups/',resourceGroup().name,'/providers/microsoft.insights/actiongroups/mail')]",
"vm_externalid_var":"[concat('/subscriptions/',subscription().subscriptionId,'/resourceGroups/',resourceGroup().name,'/providers/Microsoft.HybridCompute/machines/',parameters('vm_name'))]",
"alertrulename":"[concat('Disk (',parameters('vm_name'),')')]"
},
"resources": [
{
"type": "microsoft.insights/scheduledqueryrules",
"apiVersion": "2021-08-01",
"name": "[variables('alertrulename')]",
"location": "[parameters('location')]",
"properties": {
"displayName": "[variables('alertrulename')]",
"severity": "[parameters('alertSeverity')]",
"enabled": true,
"evaluationFrequency": "PT5M",
"scopes": [
"[variables('vm_externalid_var')]"
],
"targetResourceTypes": [
"Microsoft.HybridCompute/machines"
],
"windowSize": "PT5M",
"overrideQueryTimeRange": "P2D",
"criteria": {
"allOf": [
{
"query": "let _minValue = 20;\nPerf\n| where ObjectName == \"LogicalDisk\" and CounterName == \"% Free Space\" and InstanceName != \"_Total\" and InstanceName != \"HarddiskVolume1\" and InstanceName != \"HarddiskVolume2\"\n| where TimeGenerated >= ago(5m)\n| where CounterValue <= _minValue\n| summarize arg_max(TimeGenerated, *)by InstanceName\n| project Computer, InstanceName, CounterName, CounterValue \n",
"timeAggregation": "Average",
"metricMeasureColumn": "CounterValue",
"dimensions": [],
"operator": "GreaterThanOrEqual",
"threshold": 1,
"failingPeriods": {
"numberOfEvaluationPeriods": 1,
"minFailingPeriodsToAlert": 1
}
}
]
},
"autoMitigate": true,
"actions": {
"actionGroups": [
"[variables('actiongroup_mail_externalid_var')]"
]
}
}
}
]
}