Skip to main content

I cobbled this together from several items in the Automox Labs and API documentation:


$orgID = "myorgid"

$apiKey = 'myapikeyhere'

$filepath = ‘.\ServerInventory.csv’



$page = 0

$limit = 500

$data = @()



Write-Output "Page"



while($true) {

    $headers = @{"Authorization" = "Bearer $apiKey" }

    $url = "https://console.automox.com/api/servers?$orgID?l=$limit&p=$page"

    $response = (Invoke-WebRequest -Method Get -Uri $url -Headers $headers).Content | ConvertFrom-Json

   

    Write-Output $page

    $data += $response

    $page += 1



    if($response.count -lt $limit) {

        break

    }

}

$data | Group-Object display_name | Sort-Object name | Select-Object Count,name `

      | Export-Csv -Path $filepath -NoTypeInformation

The result is that it produces a csv of 500 server names as I’d expect. When I change “$page” to “1” in the script (and change the csv output file name) and run it again, it produces a new, blank csv.


I’ve read this: About Automox API


and feel like I’m doing it correctly, but it seems like I may be missing something - or am just doing something wrong.


Thoughts?

This is what I like to use to pull all devices. We have over 3k devices and it does it well.


$orgID = ""

$apiKey = ""



###### Get Devices

$pageindex = 0

$Items = New-Object -TypeName "System.Collections.ArrayList"

$headers = @{ "Authorization" = "Bearer $apiKey" }



Do {

	$url = "https://console.automox.com/api/servers?o=$orgID&page=$pageindex"

	$Devices =(Invoke-restmethod -Method Get -Uri $url -Headers $headers)

	foreach ($Item in $Devices) {$Items += $Item}

	$pageindex++

}

Until ($Devices.count -lt 500)

###

Thanks; I will give that a try!

Just note that your devices are all contained in the $Items object when its done.

How do you output that into a CSV?

$Items | Export-Csv -NoTypeInformation c:\temp\devices.csv

Your script ran fast and worked perfectly - thank you!

Reply


Terms & ConditionsCookie settings