WaaSUpdateStatus 數據表的查詢

裝置服務分支的散發

依服務分支散發裝置的餅圖。

WaaSUpdateStatus
| summarize arg_max(TimeGenerated, *) by ComputerID
| project ComputerID, OSServicingBranch
| summarize dcount(ComputerID) by OSServicingBranch
| render piechart

裝置 OS 版本的散發

依 OS 版本計算裝置計數。

WaaSUpdateStatus
| summarize arg_max(TimeGenerated, *) by ComputerID
| project TimeGenerated, ComputerID, OSEdition
| summarize dcount(ComputerID) by OSEdition

功能更新延遲設定

依功能更新延遲設定的裝置計數圖表。

WaaSUpdateStatus
| summarize arg_max(TimeGenerated, *) by ComputerID
| project TimeGenerated, ComputerID, FeatureDeferralDays
| summarize dcount(ComputerID) by FeatureDeferralDays
| sort by FeatureDeferralDays asc
| render columnchart

功能更新暫停設定

依功能更新暫停設定來計算裝置計數。

WaaSUpdateStatus
| summarize arg_max(TimeGenerated, *) by ComputerID
| project TimeGenerated, ComputerID, FeaturePauseState
| summarize dcount(ComputerID) by FeaturePauseState

品質更新延遲設定

依品質更新延遲設定的裝置計數圖表。

WaaSUpdateStatus
| summarize arg_max(TimeGenerated, *) by ComputerID
| project TimeGenerated, ComputerID, QualityDeferralDays
| summarize dcount(ComputerID) by QualityDeferralDays
| sort by QualityDeferralDays asc
| render columnchart

品質更新暫停設定

依品質更新暫停設定計算裝置。

WaaSUpdateStatus
| summarize arg_max(TimeGenerated, *) by ComputerID
| project TimeGenerated, ComputerID, QualityPauseState
| summarize dcount(ComputerID) by QualityPauseState