Azure Update Management Reporting

Goofoff 91 Reputation points
2020-06-30T20:48:59.537+00:00

Does anyone know how i can get a report ( monthly weekly etc.) that I can pull off Azure Update Management for my servers?
I want to be able to get down to If an auditor asks what patches were successfully applied to X server in June. Can i pull that report somehow?

Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,191 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Sam Cogan 10,342 Reputation points MVP
    2020-07-01T22:32:01.007+00:00

    You can query update management data from the log analytics workspace it is attached to. You can find the details here - https://learn.microsoft.com/en-us/azure/automation/automation-update-management-query-logs


  2. olufemia-MSFT 2,861 Reputation points
    2020-07-02T01:59:55.46+00:00

    Hello Goofoff,

    To report on what patches were successfully applied to your servers, try querying the UpdateRunProgress record as it includes the "InstallationStatus" property (among others). Use TimeGenerated to slice the result based on your desired date-time range e.g. daily, weekly.

    11185-azurereport.png

    Hope this helps.

    0 comments No comments

  3. Subhra 1 Reputation point
    2022-03-15T22:25:41.193+00:00

    where do i get the code for it or how do I run it , i am new can some one tell how to start and where to fetch the repotrt from in azure

    0 comments No comments

  4. Admin Alain Diaz Quesada 26 Reputation points
    2022-03-29T10:15:50.243+00:00

    Hi Subhra-0229

    The exact kql query may be composed like this in the azure logs.

    UpdateRunProgress
    | where TimeGenerated > ago(14h) <-- this section is used to establish the time you want to go back in records
    | summarize arg_max(TimeGenerated, Title, InstallationStatus, Resource, UpdateRunName) by UpdateId
    | project TimeGenerated, Resource, Title, InstallationStatus, UpdateRunName
    | where InstallationStatus == "Succeeded"

    0 comments No comments