Creating More Custom XML with PowerShell

Posted on January 4, 2017 by Jeff Hicks in PowerShell with

PowerShell-Text-Purple-hero

I hope you’ve been following along with my series on working with XML in PowerShell. If you are just jumping in, you definitely want to get caught up first or material in this article might not make sense. In the previous article, I demonstrated how you might use ConvertTo-XML to create a custom XML file. In this article, I want to go through an alternate process.

 

 

Before we get started, let me re-iterate the importance of planning what you intend to do with the final XML file. If your intent is to serialize data to bring back into PowerShell, then Export-Clixml is the best tool to use. And even if you need to use ConvertTo-XML, if you can start with a complete object, that will simplify the process. But let’s look at a situation in which you need to assemble an XML file from a variety of parts.

As I did in the previous article, I’m going to use a list of computer names.

With this list, I’m going to retrieve some system information from different WMI classes using Get-CimInstance. I’ll convert each result to an XML stream, which, if you recall, will be an array of XML strings.

I’m sorting the results by the computer name to make it easier to align all of the results. There’s no limit to the amount of information you might need, but I’ll keep things relatively simple. My goal is to create a single XML file that might look like the following:

Now that I know where I want to go, I can begin assembling the final file from the pieces at hand. All I’m really doing is parsing and joining text, so I’ll define a here string to begin with. This way I can add the formatted and final XML text as I process my pieces.

Next, I need to process each collection of WMI data. I’m going to trust that none of the servers I queried went offline in the middle of collecting data. The operating system and computer system results should be the same since there will be one object for each computer.

Comparing array sizes

Comparing array sizes (Image Credit: Jeff Hicks)

I can also verify the XML contents.

Viewing computer details

Viewing computer details (Image Credit: Jeff Hicks)

As I did in the last article, I need to either rename “<Object>” or take matters into my own hands. Let’s do that.

I intend to write my own XML content to the pipeline and eventually send it all to a file.  This will require some parsing and splitting of the XML content I’ve saved. Because the computer and operating system entries are the same, I can use a For loop to create the necessary beginning tags. This means I don’t need the <Object> tags. All I want is each <Property> element.

I’m creating a series of for strings, which includes indentation to make the result more legible. The output is formatted XML.

Custom XML

Custom XML (Image Credit: Jeff Hicks)

The last part is the collection of services for each computer. This is a little trickier, as I need to select the corresponding services for each computer. In my case, this means managing 1,375 services over 10 different servers. In fact, trying to parse the text I have from my original command that created $services will be extremely convoluted.

Sponsored

Instead, I’ll create a hashtable using Group-Object, where the key will be each computername.

With this hashtable, I can create an XML stream for a given computer omitting everything except the object details.

Although, as I did above, all I want are the Properties, so I’ll need to do the same type of splitting and filtering.

Splitting and Filtering Text

Splitting and Filtering Text (Image Credit: Jeff Hicks)

Let’s plug this into the For loop for each computer. I’ll need to pull the computername from the earlier data.

With this, I can get the corresponding entry from hashtable, convert the properties to XML and parse as I did earlier.

Once I know I’m getting the output I expect, I can modify my For loop to add to the here string.

I needed to add the new line marker (`n) to each line. The last step is to close the XML and save the results to a file.

But now I have the XML file I’m expecting.

Complete custom XML

Complete custom XML (Image Credit: Jeff Hicks)

Sponsored

If that seemed like a lot of work, well it was. Your head might even be spinning a bit. Sorry about that. If you truly need a custom XML file, it might be better to generate it completely from scratch using the .NET Framework. But I’ll save that for next time.

Sponsored

Tagged with , ,

Register for this Webinar