JumpCloud: Script to Pull Installed Applications on Windows via PowerShell
Purpose
This script helps you export a list of all installed applications from Windows devices managed via JumpCloud System Insights, and save them into a CSV file on your Desktop.
Prerequisites
- JumpCloud Admin Portal access
- Your JumpCloud Org ID
- Your JumpCloud API Key
- Windows PowerShell (Run as Administrator)
- System Insights must be enabled in JumpCloud
Step-by-Step Instructions
Step 1 — Prepare the Script
Copy the below script into a Notepad file:
$headers=@{}
$headers.Add("x-org-id", "Org ID")
$headers.Add("x-api-key", "API Key")
$response = Invoke-RestMethod -Uri 'https://console.jumpcloud.com/api/v2/systeminsights/programs?skip=0&limit=10000' -Method GET -Headers $headers
$response | Export-csv ~/Desktop\Windowsapplications.csv
Replace the "Org ID" and "API Key" sections with your actual values.
You can find both in your JumpCloud Admin console.
Step 2 — Run the Script in PowerShell
- Open PowerShell as Administrator
- Paste the script
- Press Enter to run
After execution completes → one CSV file named Windowsapplications.csv will be saved automatically on your Desktop.
Step 3 — Review the CSV File
Open the CSV file. You will see installed application entries along with the system_id field for each row.
This system_id helps you identify which device the application belongs to.
Step 4 — Export Device Details for Cross Reference
If you want full device details, export it from JumpCloud:
JumpCloud Console → Device Management → Devices → Export → Export CSV
Search the system_id from the applications CSV in this exported device CSV → you will get the complete device information.
Expected Result / Validation
You should now have a CSV file listing all installed Windows applications across devices, and you can identify which device each application belongs to using the system_id.
FAQs
Q1. Why is my CSV file empty?
Your API key or Org ID may be wrong. Ensure both values are correct and System Insights is enabled.
Q2. What if I get permission denied errors?
Ensure you are logged in with a JumpCloud Admin account. Regular users cannot fetch System Insights data.
Q3. Why do I see only system_id instead of device name?
System Insights does not return hostname directly in this API. Use the exported device list to map system_id to device details.
Q4. Can this fetch macOS applications too?
This script is specifically for Windows programs via the Windows program API. macOS would need a different System Insights endpoint.
