# Last Boot Times for all servers, rebooted. Bounced. # $Report = @() foreach ($machine in $SQLInstanceDev) { # Change SQL Instances to ComputerNames. $Computer = $machine.Split('\')[0] $object = Get-WmiObject win32_operatingsystem -ComputerName $Computer $Report += [pscustomobject] @{ Computer = $object.PSComputerName LastBootUpTime = $object.ConverttoDateTime($object.lastbootuptime) DayOfWeek = ($object.ConverttoDateTime($object.lastbootuptime)).DayOfWeek DaysAgo = (NEW-TIMESPAN –Start (Get-Date) –End ($object.ConverttoDateTime($object.lastbootuptime))).Days } } $Report |Sort-Object LastBootUpTime