Tools to EXPORT GPO Detailed in Excel

AMATERASOU
AMATERASOU used Ask the Experts™
on
Hello,

I need a tool to Export all GPO detailed (GPO setting) in an Excel File.

Sommething that will format it like ADM files.

I'm in a AD 2003 environment and migrating to 2008.

The goal is to have a track of all my GPOs therefofore i'll be able to consolidate them.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Emmanuel AdebayoGlobal Windows Infrastructure Engineer - Consultant
Top Expert 2013

Commented:
From the GPMC open the GPO for editing, then select ACTION>Export List and you can save it as a csv, tab-delimited text, or html

Or better still open the GPMC, right click the GPO and select "Save Report".

regards
Hi,

You could also backup GPOs using GPMC. Here you will not get the option to save it in excel file. But in GPMC you have an option 'Manage Backups' using which you could manipulate existing GPOs. You can view settings for each GPO and delete them. You can use this backup to restore GPOs. Following article has more information regarding this.

http://technet.microsoft.com/en-us/library/cc781458(v=ws.10).aspx
UC Tech Consultant
Top Expert 2013
Commented:
Hi,

Check this,

Seems like this what you are trying to achieve.

Exporting Group Policy Settings into Excel - Help Needed!!

Hope that helps :)

Commented:
GPMC should work good for you.
Or simply download group policy setting from MS-Download center to export GPO details in spreadsheets.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial