Get Azure Update Manager pending updates

[alesnav]

Hello!

I was trying to get metrics on pending Azure Update Manager updates (critical and security) and tried several times using /probe/metrics/resourcegraph, but I didn't get any results. The azure-metrics endpoint returns an HTTP 200 status code, but the response is always blank.

How can I get this information?

When I look for this same data in Resource Manager Explorer directly from the Azure Portal, I can get all the data by running this query:

patchassessmentresources
| where subscriptionId == '<SUBSCRIPTION_ID>'
| where type =~ 'microsoft.compute/virtualmachines/patchassessmentresults'
| extend 
    critical = coalesce(tolong(properties.availablePatchCountByClassification.critical), 0),
    security = coalesce(tolong(properties.availablePatchCountByClassification.security), 0)
| project 
    id, 
    name = tostring(name),
    type = tostring(type),
    location = tostring(location),
    resourceGroup = tostring(resourceGroup),
    tags = pack_all(), 
    critical = critical,
    security = security

Thanks!