How do I show everything in the custom table?

[mrdon03]

Hi

How can I display the server name and uptime all in the same custom table?
How can I insert the error message in custom table?

Below is the example of the output I am attempting to achieve

PowerShell

Server Name Uptime ----------- ------ ServerA 12/12/2020 ServerB 24/11/2020 ServerC Error

1 2 3 4 5

Server Name Uptime ----------- ------ ServerA 12/12/2020 ServerB 24/11/2020 ServerC Error

This is the code

PowerShell

Foreach ($Server in $Serverlist) { reboot_time = Get-WmiObject win32_operatingsystem -ComputerName $Server -ErrorAction Stop | %{ $_.ConvertToDateTime($_.LastBootUpTime) } $result = New-Object PsObject Add-Member -InputObject $result NoteProperty 'Server Name' $Server Add-Member -InputObject $result NoteProperty 'Uptime' $reboot_time $result | Select-Object "Server Name", "Uptime" | Format-Table -AutoSize }

1 2 3 4 5 6 7 8

Foreach ($Server in $Serverlist) { reboot_time = Get-WmiObject win32_operatingsystem -ComputerName $Server -ErrorAction Stop | %{ $_.ConvertToDateTime($_.LastBootUpTime) }   $result = New-Object PsObject Add-Member -InputObject $result NoteProperty 'Server Name' $Server Add-Member -InputObject $result NoteProperty 'Uptime' $reboot_time $result | Select-Object "Server Name", "Uptime" | Format-Table -AutoSize }

 

• This topic was modified 3 weeks, 1 day ago by mrdon03.

[ChrisM_Cologne69 Participant Topics: 0 Replies: 9 Points: 55Rank: Member]

Hmm, my first Code is gone, so I try it again.
Sorry, if there is a doublePost…

PowerShell

Foreach ($Server in $Serverlist) { $reboot_time = $(Get-WmiObject win32_operatingsystem -ComputerName $Server -Errorvariable reboot_time | ForEach-Object { $PSItem.ConvertToDateTime($PSItem.LastBootUpTime) }) 2>&1 $result = New-Object PsObject Add-Member -InputObject $result NoteProperty 'Server Name' $Server Add-Member -InputObject $result NoteProperty 'Uptime' $reboot_time $result }

1 2 3 4 5 6 7

Foreach ($Server in $Serverlist) {     $reboot_time = $(Get-WmiObject win32_operatingsystem -ComputerName $Server -Errorvariable reboot_time  | ForEach-Object { $PSItem.ConvertToDateTime($PSItem.LastBootUpTime) })  2>&1     $result = New-Object PsObject     Add-Member -InputObject $result NoteProperty 'Server Name' $Server     Add-Member -InputObject $result NoteProperty 'Uptime' $reboot_time     $result }

[mrdon03 Participant Topics: 11 Replies: 11 Points: 130Rank: Participant]

Hi it is working.

can you explain “2>&1” part ?

 

[ChrisM_Cologne69 Participant Topics: 0 Replies: 9 Points: 55Rank: Member]

There are different Output-Pipes in PS

“2>&1”

1 means the standard output pipe
2 means the error output pipe

I redirect the output from ErrorOutputPipe to the StandardOutputPipe

[Rob Simmers]

Use calculated expressions to rename the columns or perform conversions:

PowerShell

$serverList = 'Computer1' $results = Foreach ($Server in $Serverlist) { Get-CimInstance -ClassName Win32_OperatingSystem -ErrorAction Stop | Select-Object @{Name='ServerName';Expression={$Server}}, @{Name='Uptime';Expression={$_.LastBootUpTime}}, @{Name='UptimeInDays';Expression={[math]::Round((New-TimeSpan -Start $_.LastBootUpTime -End (Get-Date)).TotalDays)}}, LastBootupTime } $results

1 2 3 4 5 6 7 8 9 10 11

$serverList = 'Computer1' $results = Foreach ($Server in $Serverlist) {       Get-CimInstance -ClassName Win32_OperatingSystem  -ErrorAction Stop |     Select-Object  @{Name='ServerName';Expression={$Server}},                 @{Name='Uptime';Expression={$_.LastBootUpTime}},                 @{Name='UptimeInDays';Expression={[math]::Round((New-TimeSpan -Start $_.LastBootUpTime -End (Get-Date)).TotalDays)}},                 LastBootupTime }   $results

Note that ConvertToDateTime is not required and Powershell does the date conversion and use Get-CimInstance as Get-WmiObject is deprecated.

• This reply was modified 3 weeks ago by Rob Simmers.

[Author]

Posts