Parsing an XML file with PowerShell

Question

One of my application is generating below XML file.

<root>
    <command name="Set">
        <property name="PWR.WakeupOnLAN" value="6" errorcode="0x0"/>
    </command>
    <command name="Set">
    </command>
    <command name="biossettings">
        <property name="task" value="Succeeded." errorcode="0x0"/>
    </command>
</root>

I am interested in reading the value and errorcodes of "PWR.WakeupOnLAN" property name. Before posting here, I tried various things but couldn't find correct code for reading properties in powershell. Can any one help me with powershell code for this?

Please mark the correction answer.

JasonMArcher
– JasonMArcher

2011-05-10 06:44:18 +00:00
Commented May 10, 2011 at 6:44 — JasonMArcher
– JasonMArcher, Commented May 10, 2011 at 6:44

Enrico Campidoglio · Accepted Answer · 2011-05-09 07:43:56Z

12

In PowerShell 2.0 you can solve this using the new Select-Xml cmdlet and an XPath expression:

[xml]$document = "<root><command name='Set'><property name='PWR.WakeupOnLAN' value='6' errorcode='0x0'/></command><command name='Set'></command><command name='biossettings'><property name='task' value='Succeeded.' errorcode='0x0'/></command>"

$value = (Select-Xml -Xpath "//property[@name='PWR.WakeupOnLAN']/@value" $document).Node.Value
$errorCode = (Select-Xml -Xpath "//property[@name='PWR.WakeupOnLAN']/@errorcode" $document).Node.Value

Related resources:

edited May 9, 2011 at 7:43

answered May 9, 2011 at 7:38

Enrico Campidoglio

60.8k13 gold badges137 silver badges159 bronze badges

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

Comments

JPBlanc · Accepted Answer · 2011-05-09 08:17:52Z

8

@Enrico Campidoglio gives the "cleanest" solution here is a kind of old fashion.

PS> $xml = [XML](get-content c:\temp\yourfile.xml)
PS> $errcode = ($xml.root.command | where {$_.property.name -eq "PWR.WakeupOnLAN" }).property.errorcode

answered May 9, 2011 at 8:17

JPBlanc

73k17 gold badges137 silver badges180 bronze badges

1 Comment

Enrico Campidoglio Over a year ago

+1 for backwards compatibility. Your example will work in both PowerShell 1.0 and 2.0.

Doug Finke · Accepted Answer · 2011-05-09 12:32:22Z

2

Another possibility, is to create a function. Similar to JPBlanc's solution.

function Get-Info ($name='PWR.WakeupOnLAN', $targetXml){
    $properties = $targetXml.GetElementsByTagName("property") 
    $properties | Where {$_.Name -eq $name}
}

Get-Info -targetXml $xml
Get-Info -name Task -targetXml $xml

answered May 9, 2011 at 12:32

Doug Finke

6,8432 gold badges34 silver badges48 bronze badges

1 Comment

Sitaram Pamarthi Over a year ago

@all Thanks for the answers. These really helped me.

Collectives™ on Stack Overflow

Parsing an XML file with PowerShell

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related