Patch Installation Runs History

az graph query -q @- <<'EOF' patchinstallationresources | where type =~ "microsoft.compute/virtualmachines/patchinstallationresults" or type =~ "microsoft.hybridcompute/machines/patchinstallationresults" | where properties.lastModifiedDateTime > ago(30d) | where properties.status in~ ("Succeeded","Failed","CompletedWithWarnings","InProgress") | parse id with * 'achines/' resourceName '/patchInstallationResults/' * | project id, resourceName, type, properties.status, properties.startDateTime, properties.lastModifiedDateTime, properties.startedBy, properties, tags | union ( patchassessmentresources | where type =~ "microsoft.compute/virtualmachines/patchassessmentresults" or type =~ "microsoft.hybridcompute/machines/patchassessmentresults" | where properties.lastModifiedDateTime > ago(30d) | where properties.status in~ ("Succeeded","Failed","CompletedWithWarnings","InProgress") | parse id with * 'achines/' resourceName '/patchAssessmentResults/' * | project id, resourceName, type, properties.status, properties.startDateTime, properties.lastModifiedDateTime, properties.startedBy, properties, tags ) EOF