Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5155
  • 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-HHCommented:
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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