Jamf Pro Data Extraction Guide (for SIM Template)

Jamf Pro stores device and software data within its inventory database. The key sources of information are:

• Computers (Inventory): Contains device details such as name, ID, and operating system.

• Applications (Installed Software): Lists installed software on each computer, including name, version, and vendor/publisher.

These datasets can be retrieved through the Jamf Pro Console (UI) or via the Jamf Pro API.

Prerequisites

For Console (UI) Method

• Access to the Jamf Pro Admin Console with permissions to view Computer Inventory.

• All managed devices must have completed a recent inventory update (via jamf recon).

• Permission to export data from Inventory Reports.

For API Method

• Administrative or API access to the Jamf Pro Server.

• Jamf Pro API credentials (username and password or Bearer Token).

• Network access to the Jamf Pro server URL (e.g., https://yourcompany.jamfcloud.com).

• A working environment with PowerShell, curl, or Postman to send API requests.

You can extract software inventory data using either of the two methods below.

Option 1: Jamf Pro Console Export (UI)

This method is ideal for quick, manual exports.

1. Log in to the Jamf Pro Console.

2. Navigate to:
   Computers → Inventory → Reports.

3. Select New Advanced Search.

4. Under Display Fields, add the following:

   • Computer Name

   • Application Name

   • Application Version

   • Application Publisher (if available)

5. Click Save & View Results.

6. From the report view, click Export → CSV.

7. Save the file as JamfPro_SIM_Export.csv.

Note: If the publisher field is not available, it can be left blank or mapped manually during import.

Option 2: Jamf Pro REST API Export (Recommended for Automation)

For automated or large-scale environments, use the Jamf Pro REST API.

Step 1: Authenticate to Jamf Pro API

# Jamf Pro SIM Template Export Script
# Replace with your Jamf Pro server details

$JamfUrl = "https://yourcompany.jamfcloud.com"
$Username = "api_user"
$Password = "api_password"

# Obtain authentication token
$AuthResponse = Invoke-RestMethod -Uri "$JamfUrl/api/v1/auth/token" -Method POST -Headers @{
    "Accept" = "application/json"
} -Body @{
    username = $Username
    password = $Password
}
$Token = $AuthResponse.token

Step 2: Retrieve Device and Application Data

# Set request headers
$Headers = @{
    "Authorization" = "Bearer $Token"
    "Accept" = "application/json"
}

# Get list of computers
$Computers = Invoke-RestMethod -Uri "$JamfUrl/api/v1/computers-inventory" -Headers $Headers -Method Get

# Initialize export object
$ExportData = @()

foreach ($Computer in $Computers.results) {
    $ComputerName = $Computer.general.name
    foreach ($App in $Computer.software.applications) {
        $ExportData += [PSCustomObject]@{
            "Device Name"        = $ComputerName
            "Software Name"      = $App.name
            "Software Version"   = $App.version
            "Software Publisher" = $App.publisher
        }
    }
}

# Export to CSV
$ExportPath = "C:\Exports\JamfPro_SIM_Export.csv"
$ExportData | Export-Csv -Path $ExportPath -NoTypeInformation -Encoding UTF8

Write-Host "Export complete: $ExportPath"

This script authenticates to Jamf Pro, retrieves all computers and their installed software, and exports the data in the required SIM Template format.

Exporting to CSV

• For UI Method:
  The export is created directly from Advanced Search → Export → CSV.
  Save as JamfPro_SIM_Export.csv.

• For API Method:
  The PowerShell script automatically saves the CSV file to your chosen export path.

Ensure the resulting CSV includes the following headers:

Preparing for SIM Import

1. Open the Licenseware SIM Template.

2. Paste or import the CSV data.

Ensure no blank or extra columns remain before saving.

👉 Learn more here


Troubleshooting

Example Output

Device Name,Software Name,Software Version,Software Publisher
MBP-001,Google Chrome,129.0.6668.90,Google LLC
MBP-002,Microsoft Teams,1.7.00.12345,Microsoft Corporation
MBP-003,Slack,4.39.95,Slack Technologies
IMAC-01,Adobe Acrobat DC,24.002.20933,Adobe Inc.