NinjaOne Data Extraction Guide (for SIM Template)

NinjaOne consolidates asset and software data across managed devices via its Asset Inventory system.
The relevant information for SIM import is found in:

• Devices – Contains device and hostname information.

• Installed Applications – Lists software applications, including version and publisher details.

Data can be retrieved through either the NinjaOne Web Console export or the NinjaOne REST API.

Prerequisites

Before extracting data, ensure the following:

• You have Administrator or Report Access permissions in NinjaOne.

• Devices are actively reporting and have recent inventory data.

• Access to the Reports section or API credentials (for automation).

• (Optional) A working knowledge of PowerShell or command-line tools if using the API method.

Two main methods are supported for software inventory export from NinjaOne.

Option 1: Export via NinjaOne UI

This is the simplest and most commonly used method.

1. Log into the NinjaOne Admin Console.

2. Navigate to Reports → Assets → Installed Applications.

3. Use the filter options to include:

   • All devices (or a specific subset as required).

4. Click Generate Report.

5. Once the report is displayed, click Export → CSV.

6. Save the file (e.g., NinjaOne_SIM_Export.csv).

Ensure the following columns are visible in your export:

Option 2: Export via NinjaOne API (Advanced)

For automated or large-scale environments, use the NinjaOne REST API to programmatically extract the data.

Step 1: Obtain an API Token

1. In NinjaOne, go to Administration → Integrations → API.

2. Create an API key with read-only permissions for devices and software inventory.

3. Copy your API URL and Token.

Step 2: Run the PowerShell Script

# NinjaOne SIM Template Export Script
# Requires valid NinjaOne API credentials

# Set your API details
$NinjaBaseUrl = "https://api.ninjarmm.com/v2"
$ApiToken = "YOUR_API_TOKEN"

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

# Retrieve devices
$Devices = Invoke-RestMethod -Uri "$NinjaBaseUrl/devices" -Headers $Headers -Method Get

# Initialize array
$ExportData = @()

foreach ($Device in $Devices) {
    # Retrieve installed applications per device
    $Apps = Invoke-RestMethod -Uri "$NinjaBaseUrl/devices/$($Device.id)/software" -Headers $Headers -Method Get
    foreach ($App in $Apps) {
        $ExportData += [PSCustomObject]@{
            "Device Name"        = $Device.name
            "Software Name"      = $App.displayName
            "Software Version"   = $App.version
            "Software Publisher" = $App.publisher
        }
    }
}

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

Write-Host "Export complete: $ExportPath"

This script authenticates to NinjaOne’s API, iterates through each managed device, and collects all installed software records, outputting them in a SIM-compatible CSV format.

Exporting to CSV

If exporting manually from the UI:

1. Run the Installed Applications report.

2. Click Export → CSV.

3. Save the file as NinjaOne_SIM_Export.csv.

4. Confirm the exported headers match:

    

   Device Name,Software Name,Software Version,Software Publisher


If using the PowerShell API script, the CSV is automatically generated at the specified path.

Preparing for SIM Import

1. Open the Licenseware SIM Template.

2. Go to the Software Inventory tab.

3. Paste or import the CSV data into the sheet.

4. Verify the column order:

   Column	Expected Field
   A	Device Name
   B	Software Name
   C	Software Version
   D	Software Vendor or Publisher

👉 Learn more here

Ensure the data is clean and free of empty rows before saving.

Troubleshooting

Example Output

Device Name,Software Name,Software Version,Software Publisher
WIN-101,Google Chrome,129.0.6668.90,Google LLC
WIN-101,Microsoft Edge,130.0.2849.68,Microsoft Corporation
SRV-002,Oracle Java SE Runtime Environment,8.0.411,Oracle Corporation
LAPTOP-05,Zoom,6.1.12,Zoom Video Communications