Share via

UpdateSummary 數據表的查詢

  • 發行項

跨計算機可用的更新摘要

每部機器各類別下可用的更新計數。

// To create an alert for this query, click '+ New alert rule'
UpdateSummary 
| where TimeGenerated>ago(14h) 
| summarize by Computer, CriticalUpdatesMissing, SecurityUpdatesMissing, OtherUpdatesMissing, TotalUpdatesMissing, ResourceId

遺漏更新特定產品

WSUS 計算機成員資格。

// To create an alert for this query, click '+ New alert rule'
UpdateSummary
| summarize AggregatedValue = count() by WSUSServer, Computer, _ResourceId

自動更新組態

自動更新組態。

// To create an alert for this query, click '+ New alert rule'
UpdateSummary
| summarize AggregatedValue = count() by WindowsUpdateSetting, Computer, _ResourceId

自動更新組態已停用

已停用自動更新的電腦。

// To create an alert for this query, click '+ New alert rule'
UpdateSummary
| where WindowsUpdateSetting == "Manual" 
| sort by TimeGenerated desc