Sign in
Microsoft.com
 
Microsoft
 
 
 

none
how to parse GPO XML data into Database without duplicates using Powershell RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I am trying to parse GPO XML data into database with two columns, one as Node and other as Attribute. When I do this, there are so many duplicates. My goal is to parse GPO data into DB so that no duplicates to compare with the previous day data. Does anyone have idea about GPO XML parsing? Below are the steps that I am following.

    1. Getting all the attributes from XML and iterating through them

    2. While iterating, get the hierarchy of node.localname (like GPO,SecurityDescriptor,Permissions,TrusteePermissions,Trustee,SID)

    3. Push these attribute and node hierarchy into database

    Thanks

    Harsha

    • Moved by Bill_Stewart Tuesday, December 11, 2018 9:14 PM Unanswerable drive-by question
    Monday, July 23, 2018 4:09 AM
    |