Get-GPOReport xml and excel

Welcome Forums General PowerShell Q&A Get-GPOReport xml and excel

Viewing 2 reply threads
  • Author
    Posts
    • #192052
      Participant
      Topics: 120
      Replies: 260
      Points: 238
      Rank: Participant

      I ran Get-GPOReport on a test GPO and generated an xml file that I was hoping I'd be able to view in Excel (2013) as it does have an import xml feature ("as an XML table")

      I get an error about "Switch from current encoding to specified encoding not supported"

      I don't see any switch options from Powershell as regards to xml encoding

      [-ReportType]

      I'd like to more easily parse my GPO for easy review, filtering etc.

       

    • #193180
      Participant
      Topics: 120
      Replies: 260
      Points: 238
      Rank: Participant

      How are you reviewing your GPO's? Only in the GPMC? What's the point of exporting to an xml if you can't do anything with it?

    • #193201
      Participant
      Topics: 2
      Replies: 1001
      Points: 2,008
      Helping Hand
      Rank: Community Hero

      What you are asking for simply does not exist in the cmdlet in your question.

      Never assume a cmdlet can do X or Y. Use the help files to see what params/switches it does allow, anything not shown, is not natively possible.

      You'd end up needing to write your own proxy function to extend for what you are after or submit a feature request to MS. Unless enough folks upvote such a feature request, it won't happen in most cases.

      Why go through the Excel trip, when you can parse XML natively in PowerShell?

       

Viewing 2 reply threads
  • You must be logged in to reply to this topic.