Re: GPO Consolidation Tool?

Switch over to use of SQL 2005, even the free Express version,
as SQL speaks XML natively, although you would need to do
some schema definition work. Alternatively, use msxml object
to read in the XML and target your Access mdb from there with
ADODB (same need to define structures in Access).


"HappyCamper-PHX-" <HappyCamper-PHX-@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:AAC9EC1B-9504-4DEA-AA89-2A2130941ACA@xxxxxxxxxxxxxxxx
Please help!

I have a customer that around 3000 GPO's. I have been struggling with
collecting all the settings the GPO's have collectively. I need to import
all the settings from each GPO into one DB (MS Access db). The main
purpose
is to determine what settings are being set mostly throughout the domain.
The
goal is to consolidate to a much smaller amount of GPO.

I have been using the GPMC and the scripts that are included. I am able
to
get XMl versions of the GPO but can not import them into Access with any
meaningful structure. I have tried the same with the html format too.

Are there any tools out there MS or third parties that do what I am
asking?
Is there a way to dump the contents of a GPO into a format that MS Access
can
import?



.

Relevant Pages

  • Re: GPO Consolidation Tool?
    ... all the settings from each GPO into one DB. ... get XMl versions of the GPO but can not import them into Access with any ... I have tried the same with the html format too. ...
    (microsoft.public.win2000.group_policy)
  • Re: Frage zu Configuration Application Block
    ... Eigene Klasse mit den Config-Werten erstellen (Attribute ... Klasse Settings: ... gelich das xml File erstellen, ... section exists in one of the files and that the section 'ProSaSoftSettings' ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • Re: Registry replacement advice
    ... I use the registry for very simple stuff, ... INI files for config settings is probably your best bet. ... class file which wraps the XML library to make it easier to use without ... |>> the recordset is done and it's saved back to XML file. ...
    (microsoft.public.vb.general.discussion)
  • Re: apllication wide settings storage
    ... I have created an XML ... settings doc and would like to be able to load it and save it. ... works great if every user needs separate settings, but that is not the case. ... account for the duration of my Isolated Storage manipulations? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Using XMLHttpRequest in Firefox
    ... as said client-side script in browsers is restricted by same ... XML from http://example.com/ but not other origins." ... based on my trial of trying to load an XML file stored on my own ... But with normal settings for the ...
    (microsoft.public.scripting.jscript)
Loading