Share via

How can I download Resiliency reviews and its recommendations from review as CSV file?

Ramakrishna Abhijeet P 70 Reputation points
2024-12-02T09:20:15.8566667+00:00

I have Resiliency reviews with lot of recommendations. I need to download them as CSV using PowerShell or cli.

User's image

I'm using below Query but couldn't be able to expand the recommendations. How can I do it?
User's image

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,653 questions
Azure Advisor
Azure Advisor
An Azure personalized recommendation engine that helps users follow best practices to optimize Azure deployments.
70 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,706 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andrew Coughlin 160 Reputation points Microsoft Employee
    2024-12-11T21:20:19.0233333+00:00

    Hello Ramakrishna,

    Give this query a try:

    advisorresources

    | mv-expand workloadName = properties.resourceWorkload.name

    | where workloadName == '<Review name>'

    Where <Review Name> would be the review name that you see in the Reviews (Preview) for the specific review you are wanting to export.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.