• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5451
  • Last Modified:

Group Policy Export to Excel

Is there a way that I can export my group policy settings into Excel.  I have all my workstations in one OU wiht all the proper GPO's applied and have another OU for my servers with all the proper GPO's applied.  I would like to export the settings from each into Excel that I can give to an auditor as my baseline.  I also tried just running RSOP from a server and workstation put could figure out how to get them into Excel.  Any ideas?
0
PSGITech
Asked:
PSGITech
1 Solution
 
Mike KlineCommented:
No way that I know of to do it natively,

You could try (I may test later)

Export the gpresult to an xml file   gpresult /x   http://technet.microsoft.com/en-us/library/cc733160(v=ws.10).aspx

Then open that xml in excel   http://www.addictivetips.com/microsoft-office/excel-2010-working-with-xml-format/

Not sure how that will look/convert in excel.

Thanks

Mike
0
 
akq-HHIT ArcitectCommented:
There is one tool from Microsoft
Security Compliance Manager can export GPO's to Excel (and also compare 2 GPO's)

http://technet.microsoft.com/en-us/library/cc677002.aspx

...and there are some basic scripts out there to create an Excel file based on xml (GPMC save GPO as xml)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Become a Leader in Data Analytics

Gain the power to turn raw data into better business decisions and outcomes in your industry. Transform your career future by earning your MS in Data Analytics. WGU’s MSDA program curriculum features IT certifications from Oracle and SAS.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now