PowerShell Count

I have created this line of code which works brilliantly run from a Batch Script . . .

Code:

Powershell Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue' ^| Format-Table -Autosize ^| Out-String -Width 1000 ^| Out-File %OFN% -Append -Encoding UTF8

I then thought that I would add a Total, easier said than done.

This shows the correct Total on the screen but NOT in the output, for obvious reasons . . .

Code:

Powershell $EventCount=0; Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue' ^| ForEach{$_;$EventCount++} ^| Format-Table -Autosize ^| Out-String -Width 1000 ^| Out-File %OFN% -Append -Encoding UTF8; ' Total Events is: ' +$EventCount

So I thought that I would try and achieve this using a separate line of code. This puts the correct Total on the screen, but in the file it just shows Total Events is: . . .

Code:

Powershell $EventCount=0; Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue' ^| ForEach{$_;$EventCount++} ^| Format-Table -Autosize ^| Out-String -Width 1000 ^| Out-File %OFN% -Append -Encoding UTF8;' Total Events is: '+$EventCount

Powershell 'Total Events is: ' +$EventCount ^| Out-File %OFN% -Append -Encoding UTF8

I have spent hours on this, but I am sure that you PowerShell guys will get this straight away.

Thanks.

OK, I came up with a dirty way of achieving this . . .

Code:

Powershell Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue' ^| Format-Table -Autosize ^| Out-String -Width 1000 ^| Out-File %OFN% -Append -Encoding UTF8

Powershell 'Total Events: ' ^| Out-File %OFN% -Append -Encoding UTF8

Powershell (Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue').Count ^| Format-Table -Autosize ^| Out-String -Width 1000 ^| Out-File %OFN% -Append -Encoding UTF8

I have got to go to bed, it is gone 01:30 a.m.

I have decided to go with . . .

Code:

Powershell Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue' ^| Format-Table -Autosize ^| Out-String -Width 1000 ^| Out-File %OFN% -Append -Encoding UTF8

Powershell 'Total Events: ' + (Get-EventLog -LogName 'System' -EntryType 'Error' -After (Get-Date).AddHours(-%Period%) -ErrorAction 'SilentlyContinue').Count ^| Out-File %OFN% -Append -Encoding UTF8

I am going to mark this thread as Solved as the above code does what I want, although NOT very elegantly.