Compliance DashBoard How To export

Naresh Kumar Petalo 0 Reputation points
2024-11-07T11:52:36.18+00:00

Dear Team ,

I want to assed the policy compliance and need to prepare the policies and initiatives and which resources are non compliant as per the assignments. as per the azure portal compliance Dashboard there is no option to export the data and how ever i tried to through Azure Resource Explorer but when i compare it with Azure Portal compliance dash board it is giving different result can you please let me know how to export the compliance dashboard result as CSV .

User's image

Azure Policy
Azure Policy
An Azure service that is used to implement corporate governance and standards at scale for Azure resources.
937 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Deepanshukatara-6769 11,935 Reputation points
    2024-11-07T12:17:59.26+00:00

    Hello Naresh,

    You can try some query like this and then export in CSV

    policyresources
         | where type == "microsoft.policyinsights/componentpolicystates"
    | where properties['complianceState'] == "non-complaint"
    

    Please check this image for more detailsUser's image

    Reference :

    https://learn.microsoft.com/en-us/azure/governance/policy/how-to/export-resources?source=recommendations

    Please let us know if any further questions

    Kindly accept if it helped or woked

    Thanks
    Deepanshu

    0 comments No 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.