PowerDP

1.0.4

Functions/ConvertTo-Array.psm1

Function ConvertTo-Array {
    <#
        .SYNOPSIS
            Creates an array out of the omnirpt output
        .DESCRIPTION
            Converts the "omnirpt <...> -tab" output into a native PowerShell array for easy filtering and manipulation.
        .EXAMPLE
            omnirpt -report list_sessions -timeframe 24 24 -tab | ConvertTo-Array
        .EXAMPLE
            omnirpt -report used_media -timeframe 24 24 -tab | ConvertTo-Array | Where-Object {$_.Location -like "*HP:MSL6480*"}
        .LINK
            https://github.com/jorioux/PowerDP
    #>

    [OutputType([System.Object[]])]
    [CmdletBinding()]
    Param(
        [Parameter(ValueFromPipeline = $true)]
        [ValidateNotNullOrEmpty()]
        [string[]]$Lines
    )
    BEGIN {
        $Headers = $False
        $ArrayOutput = @()
        $i = 0
    }
    PROCESS {
        $Lines | ForEach-Object {
            $StartTime, $EndTime, $Time = $null

            #skip line if null or empty
            if([string]::IsNullOrEmpty($_)){return}

            $ArrLine = @()
            $Item = New-Object PSObject
            $i++
            #skips lines until at the headers line
            if($_.StartsWith("#")){
                #if current line contains the headers
                if($Headers -eq $True){
                    $Headers = $_.replace("# ","")
                    $Headers = $Headers.split("`t")
                    return
                }
                #if the next line contains the headers
                if($_.StartsWith("# Headers")){
                    $Headers = $True
                    return
                }
                return
            #exit if unable to fetch the headers
            } elseif($Headers -eq $False -or $Headers.Count -eq 0) {
                Write-Error "Failed to fetch the headers from the input. Make sure you use the '-tab' parameter with the omnirpt command."
                break
            }
            
            $ArrLine = $_.split("`t")

            0..($Headers.count-1) | ForEach-Object {
                if($Headers[$_] -match '^.*_t'){
                    $Time = (ConvertFrom-UnixDate $ArrLine[$_])
                    if($Headers[$_] -match '^Start.*_t'){
                        $StartTime = $Time
                    } elseif($Headers[$_] -match '^End.*_t'){
                        $EndTime = $Time
                    }
                    $Item | Add-Member -type NoteProperty -Name $Headers[$_].replace('_t','') -Value $Time
                } elseif($Headers[$_+1] -match '^.*_t') {
                    return
                } elseif($Headers[$_] -match '^Duration.*') {
                    if($StartTime -ne $null -and $EndTime -ne $null){
                        $Duration = [TimeSpan]::Parse($EndTime - $StartTime)
                    } else {
                        try {
                            $Duration = [TimeSpan]::Parse($ArrLine[$_])
                        } catch {
                            $Duration = $ArrLine[$_]
                        }
                    }
                    $Item | Add-Member -type NoteProperty -Name $Headers[$_].replace(' [hh:mm]','') -Value $Duration
                } elseif($Headers[$_] -match '^.*\[kB\]') {
                    $Size = $ArrLine[$_]/1KB/1KB
                    $Item | Add-Member -type NoteProperty -Name $Headers[$_].replace(' [kB]',' (GB)') -Value $Size
                } elseif($Headers[$_] -match '^.*\[MB/min\]') {
                    $Item | Add-Member -type NoteProperty -Name $Headers[$_].replace(' [MB/min]',' (MB/min)') -Value $ArrLine[$_]
                } else {
                    $Item | Add-Member -type NoteProperty -Name $Headers[$_] -Value $ArrLine[$_]
                }

            }

            $ArrayOutput += $Item
        }
    }
    END {
        return $ArrayOutput
    }
}