Getting servers list of purple color from update report from update manager

Question

Getting servers list of purple color from update report from update manager

sns 9,116

I have tried to generate update report from update manager.

User's image

I could navigate and see following information.

however is there any command to know below purple color details which is is giving info about "Periodic assement enabled for azure machines in not enabled" and also "Patch Orchestration configuration" is manual

I want to get the list of those servers, is it possible, if yes how?

Answer 1

AnuragSingh-MSFT 17,396

sns, Thank you for posting this question on Microsoft Q&A.

Please use the "Machines" option under Manage and the filters highlighted in the image below to get this detail:

User's image

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.

sns 9,116 Reputation points

2023-11-13T09:06:12.45+00:00

Hi Anurag,

I got it, is there any way that team can get mail or any person get mail about above update reports with detailed info list of server.?
AnuragSingh-MSFT 17,396 Reputation points

2023-11-15T08:38:47.6933333+00:00
sns, thank you for the reply.

Manually, this can be done by downloading the csv file from this view using "Export to CSV" cmd as shown below:

However, if you would like to automate this to trigger at defined schedule, it can be achieved using Resource Graph Explorer queries and logic Apps. The high-level flow can be summarized as below:

Logic App queries the "Azure Resource Graph Explorer" using KQL queries, with relevant filters and data selection/projections.

The results are then passed to an "send email" activity in Logic Apps where the message body is properly formatted.

For details on queries, use the option available in the link below to get the query from portal (which might need some modification as per your requirement): Create reports in Azure Update Manager.

For logic apps example with Azure resource graph, see Tutorial: Run Azure Resource Graph Queries in an Azure Logic App

Hope this helps. Please do post a new question if you have any followup queries.

If the answer on current question helped, please click Accept answer so that it can help others in the community looking for help on similar topics.
sns 9,116 Reputation points

2023-11-16T03:57:24.69+00:00
Hi Anurag,

I have gone through but I am not much clear on where to begin.

1.

I want report for all types of VMs about patch update status across all subscriptions.

in that case can you please give me query so that I will use same.

which one is easiest method automation account or logic apps to send mail about patch report. Please suggest. and from where I should begin. on this. Can you provide me high-level steps

Getting servers list of purple color from update report from update manager

1 answer

Activity