XML parsing with Powershell

Question

I have an xml document that I have generated from a Fortify scan. Currently I have a xml doc that looks like this:

<Chart chartType="table">
    <Axis>Fortify Priority Order</Axis>
    <MajorAttribute>Analysis</MajorAttribute>
    <GroupingSection count="2">
        <groupTitle>High</groupTitle>
    </GroupingSection>
    <GroupingSection count="101">
        <groupTitle>Low</groupTitle>
    </GroupingSection>
    <GroupingSection count="5">
        <groupTitle>Medium</groupTitle>
    </GroupingSection>
</Chart>

What I want to do is parse through this doc and pull out the High, Medium, and Low counts and assign them to a variable to pass to another script.

My problem is when I pull the xml file into powershell, how do I get the count for High findings?

Currently script:

$xml = [xml](get-content $file)

$xml.GetElementsByTagName('groupTitle') | Select-Object -Property 'High'

JPBlanc · Accepted Answer · 2017-04-20 03:47:39Z

4

Here is one way where at the end you will have 3 vars ($high, $low, $medium) :

$xml = [xml](get-content $file)
$xml.Chart.GroupingSection | % {Set-Variable -Name $_.groupTitle -Value $_.count}

Here is another way where you build an object with 3 properties :

$xml = [xml](get-content $file)
$xml.Chart.GroupingSection | % {$a=New-Object PSCustomObject}{Add-Member -InputObject $a -MemberType NoteProperty -Name $_.groupTitle -Value $_.count}

At the end consider $a :

High Low Medium
---- --- ------
2    101 5

so you can write : $a.High

edited Apr 20, 2017 at 3:47

answered Apr 20, 2017 at 3:40

JPBlanc

73.1k17 gold badges137 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SomeShinyObject · Accepted Answer · 2017-04-20 03:42:40Z

3

You can try using XPath with SelectSingleNode:

$xml.SelectSingleNode("//groupTitle[text() = 'High']").ParentNode.Count

answered Apr 20, 2017 at 3:42

SomeShinyObject

7,8316 gold badges41 silver badges60 bronze badges

1 Comment

Hemi81 Over a year ago

Thanks! I like the short version!

Esperento57 · Accepted Answer · 2017-04-20 13:56:53Z

1

other method:

[xml] $xml=[xml](gc "c:\temp\file1.xml")
($xml.Chart.GroupingSection | where groupTitle -EQ "High").count

answered Apr 20, 2017 at 13:56

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

XML parsing with Powershell

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related