ForEach with IF statements

ahmed69 · 2021-05-06T16:58:20.000Z

Hi all,

I have written the below powershell code to output to a HTML file, the issue i have is i need to add some IF; ELSEIF statements to the ForEach-Object as the text that have will change
dependant on the state of server. I have tried to this with no success, can somebody point me in the right direction

$ControllerInformation = “

Controller Information

$(Get-ControllerInformation | ConvertTo-Html -Fragment | Out-String | Add-HTMLTableAttribute -AttributeName ‘class’ -Value ‘controllertable’)” |

ForEach-Object {$_ -replace “active”, “active”}

$report = ConvertTo-Html -body “$SiteInformation $LicenseInformation $ControllerInformation” -head $CSS -Title “VDI Health Report”
$report | out-file c:\temp\report1.html

Neally · 2021-05-06T16:59:52.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2021-05-06T17:16:36.000Z

Without being able to reproduce the output, as I don’t know what it spits out, maybe something like so

$data = 
Get-ControllerInformation | 
ConvertTo-Html -Fragment | 
Out-String | 
Add-HTMLTableAttribute -AttributeName 'class' -Value 'controllertable' |
ForEach-Object {
    if($_ -eq $someValue){  
        $_ -replace "<td>active</td>", "<td style='background-color:#00FF00'>active</td>"
    }
    elseif($_ -eq $someOtherValue){
        $_ -replace "<td>inactive</td>", "<td style='background-color:#FF0000'>active</td>"
    }
    else{
        $_ -replace "<td>NotSure</td>", "<td style='background-color:#FFFF00'>active</td>"
    }
}

$ControllerInformation = "<h2>Controller Information</h2> $data"
$report = 
ConvertTo-Html -body "$SiteInformation $LicenseInformation $ControllerInformation" -head $CSS -Title "VDI Health Report"
$report | out-file c:\temp\report1.html

ahmed69 · 2021-05-07T10:38:28.000Z

Thank you for taking the time to respond Neally, really appreciate it. It does not seem evaluate what is in the IF statement () , no errors are thrown up. the output should basically display the replacement value in a particular colour (i will replace RGB codes accordingly once this is working). I have provided you with the values that are needed in the IF statement test

$data provides the below information

<table class="controllertable"><colgro><col /><col /><col /><col /><col /></colgroup><tr><th>Broker Name</th><th>State</th><th>Last Start Time</th><th>Registered VDA</th><th>Last Ac
tivity Time</th></tr><tr><td>CitrixDC.Aaminah.com</td><td>__*Active*__</td><td>06/05/2021 up15:23:17</td><td>0</td><td>07/05/2021 13:27:28</td></tr></table>

ForEach-Object {
    if($_ -eq "<td>active</td>"){  
        $_ -replace "<td>active</td>", "<td style='background-color:#00FF00'>active</td>"
    }
    elseif($_ -eq "<td>fail</td>"){
        $_ -replace "<td>fail</td>", "<td style='background-color:#FF0000'>fail</td>"
    }
    else{
        $_ -replace "<td>off</td>", "<td style='background-color:#FFFF00'>off</td>"
    }
}

gary-m-g · 2021-05-07T11:59:12.000Z

When you do if($x -eq “Something “) $x must really be the same as what’s in the quotes including spaces, special characters, et al—by default only case doesn’t matter.
It’s possible you need -like or even -match depending upon the source data.

ahmed69 · 2021-05-07T12:18:58.000Z

I have played around with -match and -like parameters, stll the result is the same. As i am only looking at some partial output from the $data out could that be the issue, Syntax wise everything looks fine. Interestingly without the IF statement a static entry works ForEach-object

ForEach-Object {$_ -replace “active”, “active”} so not sure what is going on here

Neally · 2021-05-07T12:47:40.000Z

if you don’t mind, can you post what output

Get-ControllerInformation | 
ConvertTo-Html -Fragment | 
Out-String | 
Add-HTMLTableAttribute -AttributeName 'class' -Value 'controllertable'

^ this produces?

Maybe it would be easier to match / if filter just

Get-ControllerInformation

the output of this FIRST and then convert it to html?

ahmed69 · 2021-05-07T12:51:57.000Z

This is the output from get-controller…

Broker Name	State	Last Start Time	Registered VDA	Last Activity Time
CitrixDC.Aaminah.com	Active	06/05/2021 15:23:17	0	07/05/2021 15:50:39

Neally · 2021-05-07T13:46:26.000Z

Ahmed69:

This is the output from get-controller…

Broker Name State Last Start Time Registered VDA Last Activity Time
CitrixDC.Aaminah.com Active 06/05/2021 15:23:17 0 07/05/2021 15:50:39

this seems to work fine

$input = 
@"
<table class="controllertable"><colgroup><col /><col /><col /><col /><col /></colgroup><tr><th>Broker Name</th><th>State</th><th>Last Start Time</th><th>Registered VDA</th><th>Last Activity Time</th>
</tr><tr><td>CitrixDC.Aaminah.com</td><td>InActive</td><td>06/05/2021 15:23:17</td><td>0</td><td>07/05/2021 15:50:39</td></tr></table>
"@

$data = 
$input |
ForEach-Object {
    if($_ -like '*<td>Active</td>*'){
       $_ -replace "<td>Active</td>","<td style='background-color:#00FF00'>Active</td>"
    }
    if($_ -like '*<td>InActive</td>*'){
       $_ -replace "<td>InActive</td>","<td style='background-color:#FF0000'>InActive</td>"
    }
}

$data

ahmed69 · 2021-05-07T14:12:03.000Z

Thank you very much Neally, that works now. Just need to use the -like parameter with the wildcard *, for the IF test. that works with you original code you posted. Many thanks