CSV Device Reports From Console Show Only the Public IP

Device reports (CSV exports) made from the console only show the Public IP

For quick clarification, this was done intentionally. We currently only support exporting the Public IP of a device rather than the Private IP (in CSV reports).

However, there is an alternative report you can generate through PowerShell API that can get you the information that you need! See the following script:

$logFilePath = 'C:\temp\Servers.csv'

#replace the two variables below with your Org ID and your API key
$orgID = 'YOUR_ORG_ID'
$apiKey = 'YOUR_API_KEY'

#initialize empty arrays to store Events
$Output = @()
$page = 0

#Get the json body of the Web Request
while($true) {
    $uri = "https://console.automox.com/api/servers?o=$orgID&api_key=$apiKey&limit=500&page=$page"

    $resp = (Invoke-WebRequest -UseBasicParsing -Uri $uri).Content | ConvertFrom-Json
    $Output +=  $resp |
      Select-Object Name, last_scan_failed, pending_patches, connected, last_disconnect_time, needs_attention, last_logged_in_user -Expand detail |
        Select-Object Name, MODEL, VENDOR, SERIAL, SERVICETAG, RAM, CPU, last_scan_failed, pending_patches, connected, last_disconnect_time, needs_attention, last_logged_in_user,
        @{
            n='WSUS_Server'
            e={$_.WSUS_CONFIG | Select WSUS_SERVER -expand WSUS_SERVER}
         },
         @{
            n='WSUS_Reachable'
            e={$_.WSUS_CONFIG | Select WSUS_REACHABLE -expand WSUS_REACHABLE}
         },
         @{
            n='Update_Source_Connected'
            e={$_.UPDATE_SOURCE_CHECK | Select CONNECTED -expand CONNECTED}
         },
         @{
            n='Disk_Size'
            e={($_.DISKS | Select SIZE -expand SIZE) -join "|"}
         },
         @{
            n='ip_addr'
            e={($_.NICS | Select IPS -expand IPS) -join "|"}
        },
       @{
            n='MACS'
            e={($_.NICS | Select MAC -expand MAC) -join "|"}
        },
          @{
            n='NIC_Vendor'
            e={($_.NICS | Select VENDOR -expand VENDOR) -join "|"}
        }

    if($resp.results.count -lt 500) {
        break
    }
    $page += 1
}


$Output | Export-Csv -Path $logFilePath -NoTypeInformation -Force