Need Help Please with a report

Question

I am running the below and it sends me an email that is table formated with columes Name and PSComputername. What I am trying to figure out is how can I make the table show red when the domain profile is not equal to DomainAuthenticated.

$time=[datetime]::Today.AddDays(-30)
$Servers = Get-ADComputer -Filter {LastLogonDate -gt $time -And OperatingSystem -Like 'server' } -SearchBase "OU=Domain,DC=com"
$Results = ForEach ($Server IN $Servers){
Invoke-Command -computername $Server.Name -ScriptBlock {Get-NetConnectionProfile} | Select Name,PSComputername
}
$Header = @"

"@

$HTML = $Results | ConvertTo-Html -Head $Header -PreContent "

Firewall Profile Status

" -PostContent "

Run on: $(Get-Date)
" | Out-String
Send-MailMessage -From 'Status@keyman .com' -To 'user@keyman .com -Subject 'Firewall Profile Status' -SMTPServer "mail.domain.com" -Body $html -BodyAsHtml

Accepted Answer

To do this in HTML you'll need to apply styling (or preferably CSS) to the row or cell. That isn't possible with ConvertTo-Html. It does not provide any per-row/cell formatting support. You can apply formatting to the entire table of course but that isn't sufficient.

The workaround that I've seen used is to do post-processing on the HTML to add in the styling. This can be easy or hard to do depending upon the data. For simple cases you can do string replacement. For example if you want a cell to be a different color when it has a certain value then a simple .Replace("someValue", "someValue") and include the CSS class as part of your pre content. If the rules are more complex then you have more work to do. For example if you wanted the entire row a different color then you'd need to parse the HTML string directly (perhaps using -Fragment to get just the HTML table), find the cell(s) you care about and then backtrack to the find the that marks the containing row. Not terribly difficult to do but would require a good set of helper functions and testing to get right.

Answer

I think you're going to have to forgo the use of the ConvertTo-HTML cmdlet and construct the page yourself. Using CSS is one way to accomplish the task, but you can pretty easily construct the report yourself using PowerShell. Here's an example that should work for the report you're trying to create (note that it uses the "bgcolor" for a table cell and that's been deprecated, although it's still pretty widely supported by browsers).

$DateRun = Get-Date -Format "MM/dd/yyyy hh:mm:ss tt"
$time=[datetime]::Today.AddDays(-30)
Get-ADComputer -Filter {LastLogonDate -gt $time -And OperatingSystem -Like 'server' } -SearchBase "OU=Domain,DC=com" |
    ForEach-Object{
        $tablerows = @()
        Invoke-Command -computername $_ -ScriptBlock {Get-NetConnectionProfile} -Credential $cred |
            ForEach-Object{
                if ($_.NetworkCategory -ne "DomainAuthenticated"){
                    $bgcolor = "FF0000"
                }
                Else {
                    $bgcolor = "#FFFFFF"    # White
                }
                $tablerows += @"

        $($_.NetworkCategory)
        $($_.PSComputerName)

"@
            }
    }

$HTMLstuff = @"
    
    
    
      
    
    
      Firewall Profile Status
      
        $tablerows
      
        
          
          
        
        
          NetworkCategory
          PSComputerName
        
      
        

        
Run on: $($DateRun)
      
    
    
"@

$HTMLstuff | Out-File c:\junk\x.html

Share via

Need Help Please with a report

1 additional answer

Your answer