There is a very intersting function, called New-Xml, in Jeffrey Snover's post, called Using PowerShell to Generate XML Documents.
It allows you to convert any array of objects to an XML file
function New-Xml{
param($RootTag = "ROOT",$ItemTag = "ITEM", $ChildItems = "*", $Attributes = $Null)
Begin {
$xml = "<$RootTag>`n"
}
Process {
$xml += " <$ItemTag"
if ($Attributes)
{
foreach ($attr in $_ | Get-Member -type *Property $attributes)
{
$name = $attr.Name
$xml += " $Name=`"$($_.$Name)`""
}
}
$xml += ">`n"
foreach ($child in $_ | Get-Member -Type *Property $childItems)
{
$Name = $child.Name
$xml += " <$Name>$($_.$Name)</$Name>`n"
}
$xml += " </$ItemTag>`n"
}
End {
$xml += "</$RootTag>`n"
$xml
}
}
$report = @()
foreach($cluster in Get-Cluster){
foreach($esx in (Get-VMHost -Location $cluster)){
foreach($vm in (Get-VM -Location $esx)){
$row = "" | Select Cluster,Host,VM
$row.Cluster = $cluster.Name
$row.Host = $esx.Name
$row.VM = $vm.Name
$report += $row
}
}
}
$report | New-XML -RootTag Root -ItemTag VM -ChildItems Cluster,Host,VM | `
Set-Content "C:\test.xml" This produces a rather flat XML file, but you can play around with the ChildItems and Attributes parameters.
