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.

© 2023 Foray, LLC - All Rights Reserved