Export Group Policy for Comparison

To export the group policy from a workstation or server for the purpose of comparing the policy on different machines follow these steps.

1. Open Windows PowerShell
2. Import-Module GroupPolicy
3. Get-GPOReport -All -ReportType xml -Path C:\Temp\GpoReport.xml
4. Open Microsoft Excel
5. In Excel open C:\Temp\GpoReport.xml
6. Select "As an XML table"
7. Click OK to Excel creating a schema (if prompted)
8. "Some data was imported as text" errors can be ignored
9. File->Save As
10. Save the file as a CSV

This CSV can now be compared with a different machine's report using a tool like WinMerge.