JOBNAME|TASKORDER|TASKNAME|TASKTYPE
Rate Conversions PROD|1|Copy files|CopyFile
Rate Conversions PROD|2|Excel - Convert|ExcelConvert
Rate Conversions PROD|3|Excel - Convert-Q2|ExcelConvert
Rate Conversions PROD|4|Excel - Convert-Q3|ExcelConvert
Rate Conversions PROD|5|Excel - Convert-Q4|ExcelConvert
Rate Conversions PROD|6|Get completed files|FilesList
Rate Conversions PROD|7|Set File to Load|VariableJobSet
Rate Conversions PROD|8|Run Load to DB|HTTP
Rate Conversions PROD|9|Copy files|CopyFile

##
## ListJobsTasks - List out active jobs and their tasks
##
# Get-VCAPIPath will get the path for VisualCron API DLLs
function Get-VCAPIPath
{
    $programFilesPath = if (${Env:PROCESSOR_ARCHITECTURE} -eq 'x86') { ${Env:ProgramFiles} } else { ${Env:ProgramFiles(x86)} }
    Join-Path $programFilesPath VisualCron\VisualCronAPI.dll
}

# Get-VCServer allows you to connect to the VisualCron Server
function Get-VCServer
{
    [CmdletBinding()]
    param ([string]$ComputerName, 
           [int]$Port,
           [System.Management.Automation.PSCredential]$Credential)

    $apiPath = Get-VCAPIPath
    if (!(Test-Path $apiPath)) { Throw "VisualCron does not appear to be installed. API library not found at `"$apiPath`"." }
    [Reflection.Assembly]::LoadFrom($apiPath) | Out-Null
    $conn = New-Object VisualCronAPI.Connection
    $conn.Address = if ([String]::IsNullOrEmpty($ComputerName)) { ${Env:COMPUTERNAME} } else { $ComputerName }
    if (!($credential -eq $null)) 
    {
        $conn.UseADLogon = $true
        $netcred = $credential.GetNetworkCredential()
        $conn.UserName = $netcred.UserName
        $conn.Password = $netcred.Password
    }
    $client = New-Object VisualCronAPI.Client
    $client.Connect($conn)
}

# Get-AllVCJobs returns a list of all the jobs in VisualCron server for the current machine
function Get-AllVCJobs
{
    [CmdletBinding()]
    param ([string]$ComputerName, 
           [int]$Port,
           [System.Management.Automation.PSCredential]$Credential,
           [switch]$Active)

    $ps = New-Object Collections.Hashtable($psBoundParameters)
    $ps.Remove('Active') | Out-Null
    # Connect to the Server
    $server = Get-VCServer @ps
    # Get all the jobs
    $server.Jobs.GetAll() `
    | ? { !($Active) -or $_.Stats.Active } `
    | Add-Member ScriptMethod Start { $server.Jobs.Run($this, $false, $false, $false, $null) }.GetNewClosure() -PassThru
}

function SearchTasks
{
    [CmdletBinding()]
    param ([string]$ComputerName, 
           [int]$Port,
           [System.Management.Automation.PSCredential]$Credential,
           [switch]$Active)

    $ps = New-Object Collections.Hashtable($psBoundParameters)
    $ps.Remove('Active') | Out-Null
    # Connect to the VisualCron server
    $server = Get-VCServer @ps

    # Get all the jobs
    $jobs = Get-AllVCJobs
    Write-Output ("JOBNAME" + "|" + "TASKORDER" + "|" + "TASKNAME" + "|" + "TASKTYPE")
    Foreach ($job in $jobs)
    {
      if ($job.stats.active -eq "True")
      {
        $tasks = $job.Tasks # Get the Jobs' Tasks
         Foreach ($task in $tasks)
         {
                 Write-Output ($job.Name + "|" + $task.order + "|" + $task.Name + "|" + $task.tasktype )
         }
      }  # End If job is active
    } # End foreach
    return
}  # End function SearchTasks

SearchTasks