Group Policy Export to Excel

Posted on 2012-09-21
Last Modified: 2012-10-09
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?
Question by:PSGITech
    LVL 57

    Expert Comment

    by:Mike Kline
    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

    Then open that xml in excel

    Not sure how that will look/convert in excel.


    LVL 1

    Accepted Solution

    There is one tool from Microsoft
    Security Compliance Manager can export GPO's to Excel (and also compare 2 GPO's)

    ...and there are some basic scripts out there to create an Excel file based on xml (GPMC save GPO as xml)

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Getting hacked is no longer a matter or "if you get hacked" — the 2016 cyber threat landscape is now titled "when you get hacked." When it happens — will you be proactive, or reactive?
    Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
    This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
    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…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now