Queries for the WaaSDeploymentStatus table

  • Article

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

Update deployment failures

Update deployment failures by device and update classification.

WaaSDeploymentStatus
| where DeploymentStatus == "Failed"
| summarize arg_max(TimeGenerated, *) by ComputerID, UpdateClassification 
| project Computer, ComputerID, ReleaseName, UpdateCategory, UpdateClassification, DeploymentError, DeploymentErrorCode

Devices pending reboot to complete update

Devices with pending reboot to complete update.

WaaSDeploymentStatus
| where DetailedStatus == "Reboot pending"
| summarize arg_max(TimeGenerated, *) by ComputerID, UpdateClassification
| project Computer, ComputerID, DetailedStatus, ReleaseName, UpdateCategory, UpdateClassification, LastScan

Devices with a Safeguard Hold

This query shows the device data for all devices that are impacted by safeguard holds.

WaaSDeploymentStatus
| where DetailedStatus == "Safeguard Hold"
| summarize arg_max(TimeGenerated, *) by ComputerID, UpdateClassification
| project TimeGenerated, DetailedStatus, ComputerID, ReleaseName, UpdateCategory, UpdateClassification

Target build distribution of devices with a safeguard hold

Pie chart of target build distribution of devices impacted by safeguards.

WaaSDeploymentStatus
| where DetailedStatus == "Safeguard Hold"
| summarize count(ComputerID) by TargetBuild
| render piechart