mrdon03

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Correction:

I would like the output like below format.

Server KB TimeCreated
ServerA KB12345 xxxxxxxxxxx
ServerB KB56789 xxxxxxxxxxx

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Thanks Rob That works.
One last question,

How can I catch the error for this line of code. In case of the one of the server is offline.
I would like to catch the error for that offline server while continuing the script for the rest of the server in the list.

PowerShell

$MultiSession = New-PSSession -ComputerName $Servers

1	$MultiSession = New-PSSession -ComputerName $Servers

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Hi it is working.

can you explain “2>&1” part ?

 

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Thanks. It is working now. 🙂

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Oh, thanks. It’s functioning.
I tried to add the line below and received error.

Error: the term format table is not recognized as the name of a cmdlet

PowerShell

Invoke-Command -Session $MySession -ScriptBlock { Get-MailboxDatabaseCopyStatus | Select-Object Name, Status, activationpreference | Format-Table -Autosize} }

1 2 3

Invoke-Command -Session $MySession -ScriptBlock { Get-MailboxDatabaseCopyStatus | Select-Object Name, Status, activationpreference | Format-Table -Autosize} }

 

[mrdon03]

Code Updated:

PowerShell

$outputBox = New-Object System.Windows.Forms.RichTextBox $outputBox.Multiline = $true $outputBox.BackColor = "#FDFEFE" $outputBox.Width = 960 $outputBox.Height = 630 $outputBox.ReadOnly = $true $outputBox.ScrollBars = "Both" $outputBox.WordWrap = $false $outputBox.location = new-object system.drawing.point(10, 310) $outputBox.Font = "Calibri,11,style=Bold" $Form.controls.Add($outputBox) function healthcheckinfo { $outputBox.Clear() $computers = $InputBox.lines.Split("`n") foreach ($computer in $computers) { $outputBox.AppendText($computer + ":-" + "`n") try { $RebootTime = Get-WmiObject win32_operatingsystem -ComputerName $computer -ErrorAction Stop | ForEach-Object { $_.ConvertToDateTime($_.LastBootUpTime) } $outputBox.Appendtext("Reboot time: $RebootTime`n") } catch { $outputBox.Font = "Calibri,11,style=Bold" $outputBox.SelectionColor = "#FF0000" $outputBox.Appendtext("Reboot time - Error`n") } finally { $Error.Clear() }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

$outputBox = New-Object System.Windows.Forms.RichTextBox $outputBox.Multiline = $true $outputBox.BackColor = "#FDFEFE" $outputBox.Width = 960 $outputBox.Height = 630 $outputBox.ReadOnly = $true $outputBox.ScrollBars = "Both" $outputBox.WordWrap = $false $outputBox.location = new-object system.drawing.point(10, 310) $outputBox.Font = "Calibri,11,style=Bold" $Form.controls.Add($outputBox)   function healthcheckinfo { $outputBox.Clear() $computers = $InputBox.lines.Split("`n") foreach ($computer in $computers) { $outputBox.AppendText($computer + ":-" + "`n") try { $RebootTime = Get-WmiObject win32_operatingsystem -ComputerName $computer -ErrorAction Stop | ForEach-Object { $_.ConvertToDateTime($_.LastBootUpTime) } $outputBox.Appendtext("Reboot time: $RebootTime`n") } catch { $outputBox.Font = "Calibri,11,style=Bold" $outputBox.SelectionColor = "#FF0000" $outputBox.Appendtext("Reboot time - Error`n") } finally { $Error.Clear() }

• This reply was modified 3 months, 1 week ago by mrdon03.

[mrdon03]

AndySvints wrote:

First of all, Format-Table is used only to format output in the interactive console session.

One if the options would be to loop through your $sqlservices object and append/format every value manually using spaces new lines and tabs.

Another option would be to use RTF (Reach Text Format) codes to generate a table inside reach text box:

https://docs.microsoft.com/en-us/openspecs/exchange_server_protocols/ms-oxrtfcp/65dfe2df-1b69-43fc-8ebd-21819a7463fb

Hope that helps.

Hi Andy

I came out with below code. I am trying to use the first method u suggest. It is still not working.

PowerShell

Function sqlinfo {     $outputBox.Clear()      $computers = $InputBox.lines.Split("`n")     foreach ($computer in $computers) {         try {             $outputBox.AppendText("$computer`n")             $sqlservices = Get-WmiObject Win32_Service -ComputerName $computer -ErrorAction Stop | Where-Object { ($_.Displayname -like "*sql*") }             $props = @{                 'Server Name'  = $computer;                 'Service Name' = $sqlservices.Name;                 'State'        = $sqlservices.StartMode             }             $obj = New-Object -TypeName PSCustomObject -Property $props             $outputBox.AppendText("$obj`n")         }         catch {             $outputBox.AppendText("Error`n")         }         finally {             $Error.Clear()         }     } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

Function sqlinfo {       $outputBox.Clear()        $computers = $InputBox.lines.Split("`n")       foreach ($computer in $computers) {           try {               $outputBox.AppendText("$computer`n")               $sqlservices = Get-WmiObject Win32_Service -ComputerName $computer -ErrorAction Stop | Where-Object { ($_.Displayname -like "*sql*") }               $props = @{                   'Server Name'  = $computer;                   'Service Name' = $sqlservices.Name;                   'State'        = $sqlservices.StartMode               }               $obj = New-Object -TypeName PSCustomObject -Property $props               $outputBox.AppendText("$obj`n")           }           catch {               $outputBox.AppendText("Error`n")           }           finally {               $Error.Clear()           }       }   }

• This reply was modified 3 months, 3 weeks ago by mrdon03.
• This reply was modified 3 months, 3 weeks ago by grokkit.

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Hi Andy,

Do you mind showing me example for the first method? loop through $sqlservices object and append/format every value manually using spaces new lines and tabs.

Thank you

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Resolved.

PowerShell

function pingInfo {      $outputBox.Clear()      $computers = $InputBox.lines.Split("`n")      foreach ($computer in $computers) {          if (Test-Connection $computer -Count 1 -Quiet) {             $outputBox.Font = "Calibri,11,style=Bold"             $outputBox.SelectionColor = "#007F00"             $outputBox.AppendText("$computer is Online`n")         }         else {             $outputBox.Font = "Calibri,11,style=Bold"             $outputBox.SelectionColor = "#FF0000"             $outputBox.AppendText("$computer is Offline`n")         }       }  }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

function pingInfo {        $outputBox.Clear()        $computers = $InputBox.lines.Split("`n")        foreach ($computer in $computers) {            if (Test-Connection $computer -Count 1 -Quiet) {               $outputBox.Font = "Calibri,11,style=Bold"               $outputBox.SelectionColor = "#007F00"               $outputBox.AppendText("$computer is Online`n")           }           else {               $outputBox.Font = "Calibri,11,style=Bold"               $outputBox.SelectionColor = "#FF0000"               $outputBox.AppendText("$computer is Offline`n")           }         }    }

[mrdon03]

PowerShell

Thanks. This is resolved function pingInfo { $outputBox.Clear() $computers = $InputBox.lines.Split("`n") foreach ($computer in $computers) { if (Test-Connection $computer -Count 1 -Quiet) { $outputBox.Font = "Calibri,11,style=Bold" $outputBox.SelectionColor = "#007F00" $outputBox.AppendText("$computer is Online`n") } else { $outputBox.Font = "Calibri,11,style=Bold" $outputBox.SelectionColor = "#FF0000" $outputBox.AppendText("$computer is Offline`n") } } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Thanks. This is resolved   function pingInfo { $outputBox.Clear() $computers = $InputBox.lines.Split("`n") foreach ($computer in $computers) { if (Test-Connection $computer -Count 1 -Quiet) { $outputBox.Font = "Calibri,11,style=Bold" $outputBox.SelectionColor = "#007F00" $outputBox.AppendText("$computer is Online`n") } else { $outputBox.Font = "Calibri,11,style=Bold" $outputBox.SelectionColor = "#FF0000" $outputBox.AppendText("$computer is Offline`n") } } }

• This reply was modified 3 months, 4 weeks ago by mrdon03.

[mrdon03]

AndySvints wrote:

Hello mrdon03,

Try something like this:

PowerShell

<textarea class=”urvanov-syntax-highlighter-plain print-no” style=”tab-size: 4; font-size: 14px !important; line-height: 18px !important; z-index: 0; opacity: 0;” readonly=”readonly” data-settings=”dblclick”>if (Test-Connection $computer -Count 1 -Quiet) {
$outputBox.AppendText(“$computer is Onlinen”)
}
else {
$outputBox.AppendText(“$computer is Offlinen”)
}</textarea>

1 2 3 4 5 6

if (Test-Connection $computer -Count 1 -Quiet) { $outputBox.AppendText(“$computer is Onlinen”</span><span class=”crayon-sy”>)</span></div> <div id=”urvanov-syntax-highlighter-5f72799874d13738147175-3″ class=”crayon-line”><span class=”crayon-sy”>}</span></div> <div id=”urvanov-syntax-highlighter-5f72799874d13738147175-4″ class=”crayon-line crayon-striped-line”><span class=”crayon-st”>else</span> <span class=”crayon-sy”>{</span></div> <div id=”urvanov-syntax-highlighter-5f72799874d13738147175-5″ class=”crayon-line”><span class=”crayon-v”>$outputBox</span><span class=”crayon-sy”>.</span><span class=”crayon-e”>AppendText</span><span class=”crayon-sy”>(</span><span class=”crayon-s”>”$computer is Offlinen”) }

Reference.

Hope that helps.

Thanks. Do you know how can i apply the font color as well.
For example:

computer is Online – GREEN
computer is Offline – RED

• This reply was modified 3 months, 4 weeks ago by mrdon03.
• This reply was modified 3 months, 4 weeks ago by mrdon03.

[mrdon03 Participant Topics: 12 Replies: 12 Points: 145Rank: Participant]

Code updated:

PowerShell

function pingInfo { $outputBox.Clear() $computers = $InputBox.lines.Split("`n") foreach ($computer in $computers) { if (Test-Connection $computer -Count 1 -Quiet) { $serveronline = "$computer is online" $outputBox.Appendtext("{0}`n" -f $serveronline) } else { $serveroffline = "$computer is offline" $outputBox.Appendtext("{0}`n" -f $serveroffline) } } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14

function pingInfo { $outputBox.Clear() $computers = $InputBox.lines.Split("`n") foreach ($computer in $computers) { if (Test-Connection $computer -Count 1 -Quiet) { $serveronline = "$computer is online" $outputBox.Appendtext("{0}`n" -f $serveronline) } else { $serveroffline = "$computer is offline" $outputBox.Appendtext("{0}`n" -f $serveroffline) } } }

[Author]

Posts