Queries for the WaaSUpdateStatus table

  • Article
  • 11/01/2024

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

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