Solved

Tools to EXPORT GPO Detailed in Excel

Posted on 2014-03-03
4
10,339 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 17

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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

Suggested Solutions

Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
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 enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

751 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