Worklet to identify disconnected workstations over a specific age

# Days Inactive
$DaysInactive = 14
$exportpath = 'C:\temp\automox-agents.csv'

# Get Your Org Info
$apiKey = Read-Host "api-key: "
$orgID = Read-Host "OrgID: "
$headers = @{ "Authorization" = "Bearer $apiKey" }

# Collect all devices from Automox
$i = 0
$agents = do{
    $url = "https://console.automox.com/api/servers?o=$orgID&limit=100&page=$i"
    $response = (Invoke-WebRequest -Method Get -Uri $url -Headers $headers).Content | ConvertFrom-Json
    $response
    $i++
}
while ($response)

$inactive = (Get-Date).AddDays($DaysInactive)
$axout = $agents | ForEach-Object {

    # Get just username without FQDN or UPN 
    $user = $_.last_logged_in_user
    $username = switch -wildcard ($user)
    {
        "*\*" {$user -replace [regex]".*\\",""}
        "*@*" {$user -replace [regex]"\@.*",""}
        Default {$user}
    }

    # Determine last disconnected time and if the device is inactive
    IF($_.last_disconnect_time)
    {
        $disconnect = [datetime]::parse($_.last_disconnect_time) -f 'g'
        IF($disconnect -lt $Inactive)
        {
            $status = 'Inactive'
        }
        else
        {
            $status = 'Active'
        }
    }
    else
    {
        $status = 'Active'
    }


    # Get last time device was scanned by Automox
    IF($_.last_refresh_time)
    {
        $lastscan = [datetime]::parse($_.last_refresh_time) -f 'g'
    }

    # Build output object
    [pscustomobject] @{
        'hostname' = $_.name
        'Inactive Status' = $status
        'last scan' = $lastscan
        'last disconnect' = $disconnect
        'user' = $username
        'OS' = $_.os_name
        'OS_Ver' = $_.os_version
        'last_logged_in_user' = $_.last_logged_in_user
        'serial' = $_.serial_number
        'memory' = $_.detail.ram / 1GB
        'agent version' = $_.agent_version
        'Missing # Patches' = $_.patches
        'Reboot Required' = $_.needs_reboot
    }
}
$axout | Export-Csv $exportpath -NoTypeInformation