Solved

Powershell Select from xml

Posted on 2013-06-22
4
228 Views
Last Modified: 2013-08-31
I need to be able to select from an xml based on a value then parse for specific child nodes in that parent and perform specific functions:

Here is the xml snippet:
<ServerList>
  <Server Name="SERVER01">
    <IP Address="192.16.1.1" Status="In Service" Virtual="8.8.8.55" />
    <IP Address="192.16.1.2" Status="In Service" Virtual="8.8.8.66" />
    <IP Address="192.16.1.3" Status="In Service" Virtual="8.8.8.77" />
  </Server>

  <Server Name="SERVER02">
    <IP Address="192.16.1.19" Status="In Service" Virtual="8.8.8.55" />
    <IP Address="192.16.1.14" Status="In Service" Virtual="8.8.8.66" />
    <IP Address="192.16.1.17" Status="In Service" Virtual="8.8.8.77" />
  </Server>

  <Server Name="SERVER03">
    <IP Address="192.16.1.44" Status="In Service" Virtual="8.8.8.55" />
    <IP Address="192.16.1.48" Status="In Service" Virtual="8.8.8.66" />
    <IP Address="192.16.1.56" Status="In Service" Virtual="8.8.8.77" />
  </Server>

  <Server Name="SERVER04">
    <IP Address="192.16.1.78" Status="In Service" Virtual="8.8.8.55" />
    <IP Address="192.16.1.68" Status="In Service" Virtual="8.8.8.66" />
    <IP Address="192.16.1.97" Status="In Service" Virtual="8.8.8.77" />
  </Server>
</ServerList>

Open in new window


Now I do not have any control over the xml formatting so unless someone is willing to do the heavy lifting to change the xml that is all I have to work with.

I want to be able to do something similar to below:
Select * from xml where server = "server01"

Then I want to query for all the virtuals for that machine then do a foreach loop:
e.g

foreach ($virtual in$virtuals)

{ do something}


Let me know if anyone thinks they can help :)
0
Comment
Question by:becraig
  • 3
4 Comments
 
LVL 29

Author Comment

by:becraig
ID: 39268437
Ok I got this figured out, thanks a lot guys
0
 
LVL 8

Expert Comment

by:dicconb
ID: 39407680
Good news :)

Would you consider posting the solution so other people can benefit from it?

D
0
 
LVL 29

Accepted Solution

by:
becraig earned 0 total points
ID: 39440340
Sure thing:
$var = Select-Xml -Path "path-to-file.xml" -XPath "/ServerList/Server/IP" | where { $_.Node.ParentNode.Name -eq "servername"} | % {$_.Node.Virtual} | select -unique 

Open in new window

0
 
LVL 29

Author Closing Comment

by:becraig
ID: 39454739
The key was in using _.Node.ParentNode to specify the parent node of the node I was specifying in my query.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to sign a powershell script so you can prevent tampering, and only allow users to run authorised Powershell scripts
Set OWA language and time zone in Exchange for individuals, all users or per database.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now