How to export all gpo settings in Excel

Asked By david stonjhon 10 points N/A Posted on - 12/16/2012

I would like to know how to export all GPO settings in excel, which will give details of GPO settings and its values. Please assist on how this can accomplished.

• Status: Open
• Question Views: 4276
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by grant price

Go To Solution

Best Answer

Best Answer

Answered By grant price 0 points N/A #168959

How to export all gpo settings in Excel

Hi,

I've written a vbs script which exports all GPO settings to an Excel Sheet (Only Administrative Template settings).
Make sure you have Excel installed on your computer.
Use the GPMC to export a GPO to an XML file (right click policy – save report – XML file format).
Run this script a fill in the location of the XML file.

Regards Merijn

Thank you.

 

About grant price

Questions
0

Answers
100

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 12/16/2012
• Question Category: MS Excel

Answered By Riley weaver 10 points N/A #168960

How to export all gpo settings in Excel

Hi there,

First you have to install a Remote Server Administration Tool (RSAT). Now feature the Administrative Tools and enable the Group Policy Management Console (GPMC). From GPMC select GPO for editing. Now go to action and select export from the drop down list. Now you can save the file as *.CSV file. But if you work on the server than this work can be done with Group Policy Management Tool (GPMT). You can get the *.CSV file in the same procedure.

There are also few scripts may be available but you have to do some more complex works to make it work. That is why I prefer to do this work in this way.

Thank you,

Riley Weaver.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 12/20/2012
• Question Category: MS Excel