Using the standard API call for software packages installed will just give you software installed on a single device referenced by the server ID#. This script will give you software packages installed on every device in an organization referenced by the computer names. By altering the script you can add additional fields - but make sure the Set-Content line reflects all of the fields you add to the Select-Object part of the last line of the script. You’ll also want the Set-Content line to have the fields in the same order as the Select-Object.
Available fields can be found here from the Response tab:
https://developer.automox.com/openapi/axconsole/operation/getDevicePackages/
View the script on GitHub
You can also modify it to do things like not show Windows updates & hotfixes by altering the Where-Object part of the last line of the script. For example:
Where-Object {$.installed -EQ $true -and $.repo -notlike “Windows*”}
You’ll need to set the following before running the script:
$apiKey = 'YOUR_API_KEY'
- in your console, go to Settings->API and select the API key. Note that the API key is per admin user, so you and another admin in your console will have different API keys.
$orgID = 'YOUR_ORG_ID'
- put in your Org ID which can be found by looking at the URL on the dashboard and selecting the value after the “?o=”: [https://console.automox.com/dashboard?o=1234]. In this example the Org ID is 1234.
You can also modify $filepath if you want to change the file name or save it in a different location. Keep in mind the script will overwrite a previously generated file if it exists.