使用InsightsMetrics的可用磁盘空间概述

Question

概述

我想将我的查询从使用表Virtual machines Perf转换为Virtual machines InsightsMetrics。

现状

我使用以下查询来获得一个订阅中所有azure虚拟机上可用磁盘空间的概述：

Perf
| where ObjectName == "LogicalDisk" or // the object name used in Windows records
ObjectName == "Logical Disk" // the object name used in Linux records
| where CounterName == "Free Megabytes"
| where InstanceName != "_Total"
| where InstanceName !startswith "HarddiskVolume"
| summarize arg_max(TimeGenerated, *) by CounterPath // arg_max over TimeGenerated returns the latest record
| project TimeGenerated, Drive=InstanceName, bin(FreeGB = CounterValue / 1024, 0.1), Computer
| join kind=inner (Perf
| where ObjectName == "LogicalDisk" or // the object name used in Windows records
ObjectName == "Logical Disk" // the object name used in Linux records
| where CounterName == "% Free Space"
| where InstanceName != "_Total"
| where InstanceName !startswith "HarddiskVolume"
| summarize arg_max(TimeGenerated, *) by CounterPath // arg_max over TimeGenerated returns the latest record
| project TimeGenerated, Drive=InstanceName, bin(FreePercent = CounterValue, 1), Computer)
on Drive, Computer
| project TimeGenerated, Computer, Drive, FreeGB, FreePercent
| order by Computer asc

返回如下内容：

FreeGBC:D:

	计算机	驱动器	FreePercent
2021年8月23日，14:33:35.557	hostname.domain.com	81.9	64
2021年8月23日，14:33:14.857	hostname.domain.com	73.6	98

我现在可以通过使用parse_json将查询转换为使用表Virtual machines InsightsMetrics，如下所述Shweta Lodha

这里是我的问题：

InsightsMetrics
| where Name == 'FreeSpaceMB'
| summarize arg_max(TimeGenerated, *) by Tags, Computer
| extend Drive = tostring(parse_json(Tags)["vm.azm.ms/mountId"])
| extend Size = toreal(parse_json(Tags)["vm.azm.ms/diskSizeMB"])
| project TimeGenerated, Computer, Drive, bin(SizeGB = Size / 1024, 0.1), bin(FreeGB = Val / 1024, 1)
| join kind=inner (InsightsMetrics
| where Name == "FreeSpacePercentage"
| summarize arg_max(TimeGenerated, *) by Tags, Computer
| extend Drive = tostring(parse_json(Tags)["vm.azm.ms/mountId"])
| project TimeGenerated, Computer, Drive, bin(FreePercent = Val, 1.1))
on Computer, Drive
| project TimeGenerated, Computer, Drive, SizeGB, FreeGB, FreePercent
| order by Computer asc

结果如下：

大小GB>C:

	生成的时间	计算机	驱动器	FreeGB	FreePercent
24.8.202106:33:27.000	主机名.domain.com	126.5	102	80.3