How to combine multiple update deployment runs into one report?

Question

We are running multiple scheduled deployment runs (in the same automation account) to install Microsoft patches across our environments. In the Portal, we can view the history of each deployment and it returns the results in a pretty format with the pie chart and list of machines and their deployment status.

Is there a way we can combine all of the deployment run results into one chart and list, either through queries or other methods? If there is a way to query these results and import them into Power BI, that would be a good option too. Right now, we have to manually go into each result, copy/paste the list of results into Excel, and then create our own charts there.

Note: This is for the current version of Update Management, not Update Management Center (UMC). We are aware of the new version and have previewed it.

Answer 1

@sac16 , thank you for posting this question.

The Azure Automation Update management stores all the logs in the "Log Analytics Workspace" which is connected to Azure Automation Account (it is one of the prerequisites for the Azure Automation Update Management). For details, see About Update Management.

The logs (which denotes the status) can be queried from this Log Analytics Workspace. The details of tables and columns where this information is stored are available in the link below. This link also contains sample queries that can be run on LA workspace to get results based on various scenarios - Query Update Management logs.

There are multiple ways to use these queries to create custom dashboards:

1. Azure Monitor Workbook
2. Export to PowerBI from LA Workspace
3. Dashboards in Azure Managed Grafana

Hope this helps.

If the answer did not help, please add more context/follow-up question for it, and we will help you out. Else, if the answer helped, please click Accept answer so that it can help others in the community looking for help on similar topics.