SELECT EventIndex,Time,EntryType,Source,InstanceID
FROM OpenExchangePSQuery(
POWERSHELL, '
$TimeAgo = (Get-Date).addMinutes(-1)
$servers = "ex-dag1","ex-dag2","ex-dag3","ex-cshb1","ex-cshb2"
foreach ($server in $servers)
{
$events = Get-EventLog "application" -computername $server -after $TimeAgo
foreach ($event in $events)
{
$event | select @{Name="EventIndex"; Expression = {$_.Index}},Time,EntryType,Source,InstanceID
}
}
', POWERSHELL
)
FROM OpenExchangePSQuery(
POWERSHELL, '
$TimeAgo = (Get-Date).addMinutes(-1)
$servers = "ex-dag1","ex-dag2","ex-dag3","ex-cshb1","ex-cshb2"
foreach ($server in $servers)
{
$events = Get-EventLog "application" -computername $server -after $TimeAgo
foreach ($event in $events)
{
$event | select @{Name="EventIndex"; Expression = {$_.Index}},Time,EntryType,Source,InstanceID
}
}
', POWERSHELL
)