How to export to csv file, machines list from Azure Update Management

Vlad Dodin 21 Reputation points
2022-09-12T20:34:29.48+00:00

Hi,

We have Azure Update Management enabled and working under Automation Accounts.

I have 400+ Machines added. I want to compare Excel file will "All the machines" that we actually have in the company.

My goal is to compare 2 list to see what computer needs to be added to the Updates.

Thanks,

Vlad

Azure Update Manager
Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
234 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Maxim Sergeev 6,566 Reputation points Microsoft Employee
    2022-09-14T01:42:53.953+00:00

    Hi there,

    I assume you use Update Management v1 which is required to be linked to a workspace.
    Open the linked workspace and run this query 

    Update  
| where TimeGenerated < ago (7d)  
| distinct Computer

    Save results as csv\excel

    240749-image.png

    1 person found this answer helpful.
    0 comments
  2. Vlad Dodin 21 Reputation points
    2022-11-18T15:02:07.397+00:00

    Thank you so much, exactly what I've needed!

    Vlad

    0 comments