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

1. Open PowerShell as Administrator
2. Paste the script
3. 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.