Vivek's Blog: Powershell output handling using HTML

HTML Report in PowerShell - Using HTML Tables

Here I am going to cover how to handle PowerShell output using html table.

Benefits of html output : We will be able to do the different types of formatting using html like table creation, coloring,font style etc, but we need to know some basic html language to do a better formatting. Below url help you to learn the basics of html.So if you are a beginner in html language, please go through the below url and understand the basics of html.

Learn Html Basic - W3Schools.com

Scenario : Fetching System Properties :

Through this example, I am using get-wmiobject to get some system details and passing the output to html tables.Here we have to decide the output design before creating script... Like output heading , table's rows,columns, heading, color, graphs design and location etc:

Please note the below html tags for basic understandings:

001

002

003

004

005

006

<Table>     : Table Craetion

<tr>        : Table row

<td>        : Table Data

<h1>        : Heading size

<bgcolor>   : Color of the table. You can change as per your wish

<align>     : Alignment of table and table data

1 - Creating heading for table and output:

001

002

003

004

005

006

007

008

009

$Table =

{

'<table width=40% align=center>'

'<th align="center"> <h3><font color=red>SYSTEM PROPERTIES<h3></th>'

'</table>'

'<table border="1" width=40% align=center>'

'<tr bgcolor=skyblue>'

'<th>HOST NAME</th><th>OPERATING SYSTEM NAME</th><th>SERIAL NO</th>'

}

This will be the head part of your output. Table width,height and alignment can be customize as per your requirement. In this example, the output heading will be SYSTEM PROPERTIES and I am fetching the below three details of a computer

HOST NAME

OPERATING SYSTEM NAME

SERIAL NO

The format will looks like below:

2 - Process Creation : Using get-wmiobject to retrive the system details and passing the result through html.

001

$Sysdetails = Get-WmiObject -Class win32_operatingsystem -ComputerName $_

001

002

003

004

005

006

007

008

009

010

011

012

013

014

015

016

017

018

019

020

021

022

023

024

025

026

027

028

029

030

031

$process=

{

    Get-Content $env:USerProfile\desktop\pc.txt | foreach {

    '<tr>'

    '<td align="center" >{0}</td>' -f $_

    if(!(Test-Connection -Cn $_ -BufferSize 16 -Count 1 -ea 0 -quiet))

    {

        $failed = "Failed to Ping"

        '<td bgcolor = orange align = center>{0}</td><td bgcolor = orange align = center>{1}</td>' -f $failed,$failed

    }

    else

    {

        $Error.Clear()

        $Sysdetails = Get-WmiObject -Class win32_operatingsystem -ComputerName $_

        if($Error[0])

            {

            $unknown = "Unknown"

            '<td bgcolor = yellow align = center>{0}</td> <td bgcolor = yellow align = center>{1}</td>' -f $unknown,$unknown

            }

        else

            {

            '<td bgcolor=lightgreen align=center>{0}</td> <td bgcolor=lightgreen align=center>{1}</td>' -f $Sysdetails.Caption,$Sysdetails.SerialNumber

            }

        }'<tr>'

       $Sysdetails = $null

       }

       # Foreach End

}

#Process End

$Tableend

3 - Report Generation Part : Path Creation, report generation and opening the html file

001

002

003

004

$Path = "$env:USerProfile\desktop\SysDetails.html"

ForEach-Object -Begin $table -Process $process -End $tableend |

Set-Content -Path $Path -Encoding ascii

Invoke-Expression $Path