Vista - RE: Reading XML Patch File for ESX in PowerShell

What do you want as output
--
Richard Siddaway
Please note that all scripts are supplied "as is" and with no warranty
Blog: http://richardsiddaway.spaces.live.com/
PowerShell User Group: http://www.get-psuguk.org.uk


"dm3281" wrote:

Hi, basically the entire file in column format by ESX version...

I.E. -- all patches related to ESX350, then ESX302, then ESX301... all
columns except md5.



"RichS" <RichS@xxxxxx> wrote in message
news:EB8585F5-303E-4C47-8C9F-4D91AB1DC9BD@xxxxxx

This is what I came up with... but I don't like how I have to know to use
"esx301" or "esx302" for the node.

[xml] $patches = get-content c:\temp\esxupdate.xml
foreach ($p in $patches.esx) {
foreach ($i in $p.esx302) {
$match = new-object PsObject
$match | add-member NoteProperty Patch $i.patch
$match | add-member NoteProperty Date $i.date
$match | add-member NoteProperty Classification $i.classification
$match | add-member NoteProperty Summary $i.summary
write-host $match.Patch, $match.date, $match.Classification,
$match.Summary
# $match | format-table -hideTableHeaders -autosize
}
}
foreach ($p in $patches.esx) {
foreach ($i in $p.esx301) {
$match = new-object PsObject
$match | add-member NoteProperty Patch $i.patch
$match | add-member NoteProperty Date $i.date
$match | add-member NoteProperty Classification $i.classification
$match | add-member NoteProperty Summary $i.summary
write-host $match.Patch, $match.date, $match.Classification,
$match.Summary
# $match | format-table -hideTableHeaders -autosize
}
}


Also, I'm not sure if using add-member is necessary for displaying a
columnar output, I tried write-host $i.patch + " " + $i.date etc, but got
conversion mismatch errors, etc???






"dm3281" <dm3281@xxxxxx> wrote in message
news:F1E00A91-808D-475F-8355-76035E7F9AE7@xxxxxx

Try this:

$esxupdate.esx | gm esx* | % {$esxupdate.esx.$($_.name)} |
select name, patch, date, classification, summary | ft -a -w

--
Kiron

Is there anyway I can get it not to display the name column?



[xml] $patches = get-content c:\temp\esxupdate.xml
$patches.esx | gm esx* | % {$patches.esx.$($_.name)} | select name, patch, date, classification, summary | ft -a -w




"Kiron" <Kiron@xxxxxx> wrote in message news:70D906BB-70DF-4FB7-9FC3-85E4F420ADF5@xxxxxx
Try this:

$esxupdate.esx | gm esx* | % {$esxupdate.esx.$($_.name)} |
select name, patch, date, classification, summary | ft -a -w

--
Kiron

Sure, remove the property from Select:

[xml] $patches = get-content c:\temp\esxupdate.xml
$patches.esx | gm esx* | % {$patches.esx.$($_.name)} | select patch, date, classification, summary | ft -a -w

--
Kiron

Thanks, for some reason I didn't catch that.

Do you know how I can have it sort by ESX301, ESX302, etc, and also date?




"Kiron" <Kiron@xxxxxx> wrote in message
news:%23RhUgXJXIHA.3556@xxxxxx

Sort before Select. Note the use of a calculated property to sort on Date:

$patches.esx | gm esx* | % {$patches.esx.$($_.name)} | sort name, @{expression = {[datetime]$_.date}} | select patch, date, classification, summary | ft -a -w

# this works also:
$patches.esx | gm esx* | % {$patches.esx.$($_.name)} | sort name, {[datetime]$_.date} | select patch, date, classification, summary | ft -a -w

--
Kiron

That worked. Thank you!



"Kiron" <Kiron@xxxxxx> wrote in message
news:u3ZOJnJXIHA.1168@xxxxxx