Powershell script to search an XML sub-elements

Question

Hello I'm having problem trying to get the values of one node with certain name from XML.

For example:

<Smart>
  <Settings>
    <Service name="9003">
       <Config imports="router">
           <Section name="x">
                <Parameter name="a" value="0" />
                <Parameter name="b" value="1" />
                <Parameter name="c" value="2" />
                <Parameter name="d" value="3" />
                <Parameter name="e" value="4" />
           </Section>
        </Config>
    </Service>
    <Service name="9004">
       <Config imports="router">
           <Section name="x">
                <Parameter name="a" value="5" />
                <Parameter name="b" value="6" />
                <Parameter name="c" value="7" />
                <Parameter name="d" value="8" />
                <Parameter name="e" value="9" />
           </Section>
        </Config>
    </Service>
  </Settings>
</Smart>

I want to get the value '9' from the Parameter named as "e" from the Service "9004" and then export or print it using the Write-Host.

Any ideas? I was trying this but it is returning nothing to me.

    # Read the XML file
    Write-Host "OPENING XML FILE";
    $path = "\\$computer\$FileName"
    [xml] $xml = Get-Content $path
    
    # Filter the XML
    $SectionName = "x"
    $Section = $xml.Smart.Settings.Config.Section| Where-Object {$_.name -eq $SectionName}
    Write-Host $Section

Gordon · Accepted Answer · 2021-03-02 08:57:53Z

1

@Brazs, try using XPath to select the element based on the path and name value, like so

$parameterElement = $xml.SelectSingleNode("//Section[@name='$SectionName']/Parameter[@name='e']")

You can get to the attribute value directly like this

$parameterElement.value

or with a method

$parameterElement.GetAttribute('value')

EDIT: The search criteria can be expanded too, so

$parameterElement = $xml.SelectSingleNode("//Service[@name='$ServiceName']/Config/Section[@name='$SectionName']/Parameter[@name='e']")

finds the required service, any config, the required section and the 'e' Parameter. I leave it to you to figure out how to expand on that for a specific config or variable Parameter, for example.

edited Mar 2, 2021 at 8:57

answered Mar 2, 2021 at 6:32

Gordon

7,0178 gold badges51 silver badges133 bronze badges

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

2 Comments

Brazs Over a year ago

Hi @Gordon, thank you so much. It worked, but since my xml file structure change I am getting the value from the first Section. I want to get it from the second. Can you help me?

Brazs Over a year ago

Thank you Gordon. I could solve the issue with your idea.

postanote · Accepted Answer · 2021-03-02 10:19:05Z

0

A bit of a different approach to allow you to dynamically cherry-pick as needed.

[xml]$XmlData = @'
<Smart>
  <Settings>
    <Config imports="alpha">
        <Section name="x">
           <Parameter name="a" value="true" />
           <Parameter name="b" value="0" />
           <Parameter name="c" value="13873" />
           <Parameter name="d" value="true" />
           <Parameter name="e" value="EAI" />
        </Section>
        <Section name="y">
           <Parameter name="a" value="false" />
           <Parameter name="b" value="1" />
           <Parameter name="c" value="13874" />
           <Parameter name="d" value="false" />
           <Parameter name="e" value="EAI1" />
        </Section>
    </Config>
  </Settings>
</Smart>
'@


($SectionData = Select-Xml -Xml $XmlData -XPath '//Section').Node 
# Results
<#
name Parameter      
---- ---------      
x    {a, b, c, d, e}
y    {a, b, c, d, e}
#>

$SectionData.Node.SyncRoot | 
Where-Object name -eq 'x' 
# Results
<#
name Parameter      
---- ---------      
x    {a, b, c, d, e}
#>


($SectionData.Node.SyncRoot | 
Where-Object name -eq 'x').Parameter | 
Where-Object name -eq 'e'
# Results
<#
name value
---- -----
e    EAI 
#>


(($SectionData.Node.SyncRoot | 
Where-Object name -eq 'x').Parameter | 
Where-Object name -eq 'e').Value
# Results
<#
EAI
#>

Using your numbers XMLData, then this:

(((($SectionData.Node.SyncRoot | 
Where-Object name -eq '9003').Config).Section).Parameter | 
Where-Object -Property name -eq 'e').Value
# Results
<#
4
#>

edited Mar 2, 2021 at 10:19

answered Mar 2, 2021 at 9:04

postanote

16.4k3 gold badges17 silver badges29 bronze badges

1 Comment

postanote Over a year ago

No worries. we do what we can and PowerShell offers a number of ways to address X or Y use case(s). The above can be turned into a function, using dynamicparameters to get IntelliSense on properties and spit out the results on the selection. I.e. Show-XMlData -Section x -Parameter e.

Collectives™ on Stack Overflow

Powershell script to search an XML sub-elements

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related