AutoTask

AutoTask.ps1

# one-time installation
Install-Module -Name Autotask

# initialize
Import-Module Autotask
$Credential = Get-Credential
Connect-AutotaskWebAPI -Credential $Credential

function ArrayToHash($a)
{
    $hash = @{}
    $a | %{ $hash[$_.Value] = $_.Label }
    return $hash
}

# get status & queue mappings
$fieldinfo = Get-AtwsFieldInfo "Ticket"
$statuslist = ArrayToHash(($fieldinfo | ?{ $_.Name -eq 'status'})[0].PickListValues)
$queuelist = ArrayToHash(($fieldinfo | ?{ $_.Name -eq 'queueid'})[0].PickListValues)

# load non-complete tickets
$tickets = Get-AtwsTicket -Status 'Complete' -NotEquals 'Status'

# resolve queue and status
$tickets2 = `
    $tickets `
        | select `
            TicketNumber, `
            CreateDate, `
            @{Name='Queue'; Expr={$queuelist[[string]$_.QueueId]}}, `
            @{Name='Status'; Expr={$statuslist[[string]$_.Status]}}

# tickets per Queue/Status
$tickets2 `
    | Group-Object Queue, Status `
    | select Name, Count `
    | sort Name
    
# tickets per Queue/Status, with first/last ticket
$tickets2 `
    | group Queue, Status `
    | sort Name `
    | select `
        Name, `
        Count, `
        @{Name='First'; Expr={ ($_.Group.CreateDate | measure -Min).Minimum } }, `
        @{Name='Last'; Expr={ ($_.Group.CreateDate | measure -Max).Maximum } }
        
# tickets per Queue/Status 
$tickets2 `
    | group Queue, Status `
    | select @{Name="Queue";Expr={$_.Group[0].Queue}}, @{Name="Status";Expr={$_.Group[0].Status}}, Count `
    | sort Queue, Status `
    | ConvertTo-Csv `
    #> .\tickets.csv
    
# tickets per Queue/Status (split queue/status, correct headings, tab-delimiter)
$tickets2 `
    | group Queue, Status `
    | select @{Name="Queue";Expr={$_.Group[0].Queue}}, @{Name="Status";Expr={$_.Group[0].Status}}, Count `
    | sort Queue, Status `
    | ConvertTo-Csv -Delimiter "`t" -NoTypeInformation `
    #> .\tickets-v2.csv