next »

[bmmikee]

I'm using a reporting script that works very well.  When it reports on error messages from all hosts it just bunches them together in one block.  I'm wondering if its possible to seperate them on a per host basis?  As in list the individual host, then error messages and so forth.  This is the code that is being used to pull them:

###############################
# Errors the last 24 hours   #
###############################
# Get-VIEvent -Start (Get-Date).AddHours(-120) -Type Error | Format-Table CreatedTime, FullFormattedMessage -AutoSize | ConvertTo-Html -title "Errors the last five days" -body "<H2>Errors the last 5 days.</H2>" | Out-File -Append $filelocation
Get-VIEvent -Start (Get-Date).AddHours(-120) -Type Error | Select-object CreatedTime, FullFormattedMessage | ConvertTo-Html -title "Errors the last five days" -body "<H2>Errors the last 5 days.</H2>" | Out-File -Append $filelocation

[esarakaitis]

does it do the same thing when your not using convertto-html?

[ewannema]

To do what you want you need to extract the host property and then sort by it.  You can grab the records using a slight modification of your technique.

Code:

Get-VIEvent -Start (Get-Date).AddHours(-120) -Type Error | ForEach-Object {$_ | Select-Object CreatedTime, @{Name="Host"; Expression={$_.Host.Name}}, FullFormattedMessage} | Sort-Object -Property Host,CreatedTime

Note that not all events will be associated with hosts so that field will most likely be blank in that case.