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

  • Question

  • 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



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