Look for WU install dates for all servers.
$DayOfWeek = @{n='DayOfWeek';e={ ($_.LastRunTime).DayOfWeek }}
$Computer = @{n='Computer';e={$ComputerName}}
$TimeFromNow = @{n='HoursFromNow';e={"{0}" -f (New-TimeSpan -Start (Get-date) -End $_.NextRunTime) } }
$SQLInstanceDev + $SQLInstanceTEST + $SQLInstancePROD | %{
$ComputerName = $_.Split('\')[0]
Write-Host $ComputerName
# Actually get STATE for Windows Updates for each computer
.\adhoc\Get-ScheduledTask.ps1 -ComputerName $ComputerName |
Where-Object {$_.Name -in 'ProgramDataUpdater','AUScheduledInstall' } |
Select-Object $Computer, $TimeFromNow, Name, State, Enabled, LastRunTime, NextRunTime, ComputerName, $DayOfWeek
} | Out-GridView
