Compliance DashBoard How To export

Question

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 .

Answer 1

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 details

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