Solved

Tools to EXPORT GPO Detailed in Excel

Posted on 2014-03-03
4
11,105 Views
Last Modified: 2014-03-31
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.
0
Comment
Question by:AMATERASOU
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 18

Expert Comment

by:Emmanuel Adebayo
ID: 39900087
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
0
 
LVL 12

Expert Comment

by:SreRaj
ID: 39900313
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
0
 
LVL 9

Accepted Solution

by:
VirastaR earned 500 total points
ID: 39901184
Hi,

Check this,

Seems like this what you are trying to achieve.

Exporting Group Policy Settings into Excel - Help Needed!!

Hope that helps :)
0
 
LVL 2

Expert Comment

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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question