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.