Azure Update Manager

Kabelo Phefo 0

Hi,

Need help with powershell script to query azure update manager for Windows update for Arc enabled servers

Tech-Hyd-1989 5,791 Reputation points

2023-09-13T10:58:10.01+00:00
Hello Kabelo Phefo

Here is a PowerShell script that you can use to query Azure Update Manager for Windows update for Arc enabled servers:

# Import the Azure Update Management module Import-Module AzureRM.UpdateManagement # Get the list of Arc enabled servers $servers = Get-AzArcMachine # Loop through the servers and query for Windows updates foreach ($server in $servers) { # Get the list of Windows updates for the server $updates = Get-AzUpdateConfigurationForMachine -MachineName $server.Name # Print the list of updates Write-Host "Windows updates for $server.Name:" foreach ($update in $updates) { Write-Host " - $update.Title" } }

This script will first import the Azure Update Management module. Then, it will get the list of Arc enabled servers. Next, it will loop through the servers and query for Windows updates for each server. Finally, it will print the list of updates for each server.

To run this script, you will need to have the Azure PowerShell module installed. You can install the module by running the following command:

Install-Module AzureRM

Once the module is installed, you can run the script by running the following command:

.\QueryAzureUpdateManagerForWindowsUpdates.ps1

This script will query Azure Update Manager for Windows updates for all Arc enabled servers in your subscription. The results of the query will be printed to the console.

I hope this helps! Let me know if you have any other questions.
tbgangav-MSFT 10,416 Reputation points

2023-09-14T09:46:47.4866667+00:00

Hi @Kabelo Phefo ,

Just checking in to see if you got chance to look at my earlier response.

1 answer

tbgangav-MSFT 10,416 Reputation points

2023-09-13T12:13:26.99+00:00

Hi @Kabelo Phefo ,

As per this document, logs created from operations like update assessments and installations are stored by Update Manager in Azure Resource Graph and as per this document, Search-AzGraph is the Azure PowerShell cmdlet using which we can query the resources managed by Azure Resource Manager so you could come up with your Azure Resource Graph kusto query by including all the filters that are required for your environment and then use that in the Search-AzGraph Azure PowerShell cmdlet and save it as PowerShell script.

You may refer examples in this document to understand how to include kusto query inside the Search-AzGraph cmdlet. Also, you may refer this document to understand the structure of logs being sent by Update Manager for all of its operations to Azure Resource Graph and refer this document for sample queries so you could come up with your real-time Azure Resource Graph kusto query for your use case scenario.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure Update Manager

1 answer

Your answer