List WSUS groups and add content to HTML file

Question

List WSUS groups and add content to HTML file

Sebastian Jesior 166

Hello Team,

I'm preparing powershell script which lists WSUS groups and counts members. Now I need to add this content to HTML file. Unfortunatelly it is not working and I can see results in powershell console:

foreach( $group in $wsus.GetComputerTargetGroups() ) 
{ 
    Write-Host "Group: " $group.Name " - " $group.GetComputerTargets().Count " member(s)" | ConvertTo-Html | Add-Content "C:\Scripts\WSUS.htm"
}

obraz

May I kindl ask you to help me and tell what is wrong in this code?

Regards, Sebastian

Accepted answer

1 additional answer

Your answer

Answer 1

MotoX80 36,291

Write-Host is sending the output to the console and not to the pipeline and on to ConvertTo-Html.

Try this.

"Group: " + $group.Name + " - " + $group.GetComputerTargets().Count + " member(s)" | ConvertTo-Html | Add-Content "C:\Scripts\WSUS.htm"

Personally, I prefer this method for formatting.

"Group: {0} - {1} member(s)" -f $group.Name, $group.GetComputerTargets().Count | ConvertTo-Html | Add-Content "C:\Scripts\WSUS.htm"

I don't think that ConvertTo-Html is going to do what you want it to do. Let me see if I can get that working too.

Sebastian Jesior 166 Reputation points

2023-04-02T17:26:25.4666667+00:00

Hello,

Thank you very much for your help.

I have checked these 2 options but still not working correctly. Please check results below:

MotoX80 36,291

Maybe something like this, where I just list some files in C:\Windows. Looks like Convertto-html is expecting an object and not a string.

$report = foreach ($group in (Get-ChildItem C:\Windows -File))
{ 
    "Group: " + $group.Name + " - " + $group.length + " member(s)<br>" 
} 

ConvertTo-Html -Body $report | Out-File "C:\temp\test.htm" 
""
"Here is the html"
""
Get-Content C:\temp\test.htm

User's image

See also: https://4sysops.com/archives/building-html-reports-in-powershell-with-convertto-html/

This looks better.

Get-ChildItem C:\Windows -File | Select-Object -Property Name, Length | ConvertTo-Html  | Out-File "C:\temp\test.htm" 
""
"Here is the html"
""
Get-Content C:\temp\test.htm

Sebastian Jesior 166 Reputation points

2023-04-02T18:28:18.3333333+00:00

Thank you.

This is working fine :)

MotoX80 36,291

Another way.

$report = foreach ($group in $wsus.GetComputerTargetGroups())
{ 
   [PSCustomObject]@{ 
     "Group" = $group.Name
     "Members" =  $group.GetComputerTargets().Count  
     }
} 

$report |  ConvertTo-Html  | Out-File "C:\temp\test.htm"

Answer 2

Rich Matheisen 47,901

You can use Select-Object with "calculated properties", but I like this better:

$wsus.GetComputerTargetGroups() |
    ForEach-Object{ 
        [pscustomobject]@{
            Group = $_.Name
            "Member Count" = $_.GetComputerTargets().Count
        }
    } | 
        ConvertTo-HTML | 
            Add-Content "C:\Scripts\WSUS.htm"

Share via

List WSUS groups and add content to HTML file

1 additional answer

Your answer