How do I create an easy-to-read report/query of all my machines in Azure Update Manager and the Maintenance Configuration they are a part of?

Question

I am looking to create a report/query that our Service Management team can view so they and other members of our IT team can easily view all of our machines in Azure Update Manager and what maintenance configuration they are assigned to. I want to do this to replace the current Excel spreadsheet we have for our patching schedule.

Answer 1

@Oliver Tomlinson For your requirement, you can leverage the logs stored by Azure Update Manager in Azure Resource Graph. The table maintenanceresources in ARG includes resources related to maintenance configuration. To see available logs related to Azure Update Manager, you can refer this document and for sample queries , you can refer this document.