Queries for the UpdateRunProgress table
Patch installation failure for your machines
List for each machine the installation status of the updates where the installation was not successful.
// To create an alert for this query, click '+ New alert rule'
UpdateRunProgress
| where TimeGenerated>ago(1d)
| where InstallationStatus == "NotStarted"
| summarize by Title, InstallationStatus, SourceComputerId, UpdateId, Computer, ResourceId
| join kind= inner (
UpdateRunProgress
| where TimeGenerated>ago(1d)
| where InstallationStatus != "NotStarted"
| summarize by Title, InstallationStatus, SourceComputerId, UpdateId, Computer
) on UpdateId
| where InstallationStatus1 != "Succeed"
| summarize by Title, InstallationStatus, Computer, ResourceId
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for