Queries for the WaaSUpdateStatus table

  • Article

Distribution of device Servicing Branch

Pie chart of devices distribution by servicing branch.

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

Distribution of device OS Edition

Counts devices by OS edition.

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

Feature Update Deferral Configurations

Chart of device count by feature update deferral configurations.

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

Feature Update Pause Configurations

Count devices by feature update pause configurations.

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

Quality Update Deferral Configurations

Chart of device count by quality update deferral configurations.

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

Quality Update Pause Configurations

Count devices by quality update pause configurations.

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