ManageEngine Data Extraction Guide (for SIM Template)

ManageEngine Endpoint Central gathers detailed endpoint information from managed devices.
The relevant software inventory data resides in the following modules:

• Inventory → Software Details: Lists all detected software applications, including name, version, and publisher.

• Inventory → Computers: Contains device information such as hostname, OS, and last scan time.

This data can be retrieved through the web console or the ManageEngine REST API.

Prerequisites

For Console (UI) Method

• Access to the ManageEngine Endpoint Central or Desktop Central console with Inventory privileges.

• Endpoint scans completed recently (ensure up-to-date data).

• Permission to export reports from the Inventory → Software module.

For API Method

• Administrative or API access to the Endpoint Central server.

• API key or credentials for authentication.

• Network access to the Endpoint Central server (typically https://<server>:8020 or via secure HTTPS port).

• A working PowerShell or curl environment for issuing REST API calls.

Two methods are available to extract the required data for SIM Template import.

Option 1: ManageEngine Console Export (UI)

This is the simplest and most commonly used method.

1. Log in to the Endpoint Central Console.

2. Navigate to:
   Inventory → Software → All Software

3. In the top-right corner, click Export → CSV.

4. Choose your export format and save the file (e.g., ManageEngine_SIM_Export.csv).

5. Ensure the following columns are visible in your export:

Tip: If the exported CSV includes extra columns (e.g., installation date or license type), these can be safely removed before import into the SIM Template.

Option 2: ManageEngine API Export (Advanced / Automated)

ManageEngine provides an API endpoint for retrieving software details programmatically.
The following PowerShell example demonstrates how to authenticate and export software inventory data in a format suitable for the SIM Template.

Step 1: Define Server and API Details

# ManageEngine SIM Template Export Script
# Update these variables with your environment details

$Server = "https://your-endpointcentral-server:8020"
$ApiKey = "YOUR_API_KEY"
$ExportPath = "C:\Exports\ManageEngine_SIM_Export.csv"

Step 2: Retrieve Software Inventory

# Set request headers
$Headers = @{
    "Authorization" = "Zoho-authtoken $ApiKey"
    "Accept"        = "application/json"
}

# API endpoint for software inventory
$Url = "$Server/api/1.3/inventory/software"

# Retrieve data
$Response = Invoke-RestMethod -Uri $Url -Headers $Headers -Method Get

# Initialize array
$ExportData = @()

foreach ($Device in $Response.result.devices) {
    foreach ($App in $Device.software_list) {
        $ExportData += [PSCustomObject]@{
            "Device Name"        = $Device.device_name
            "Software Name"      = $App.software_name
            "Software Version"   = $App.version
            "Software Publisher" = $App.vendor
        }
    }
}

# Export to CSV
$ExportData | Export-Csv -Path $ExportPath -NoTypeInformation -Encoding UTF8
Write-Host "Export complete: $ExportPath"

This script connects to the Endpoint Central API, retrieves software data per device, and exports it in a structure compatible with the Licenseware SIM Template.

Exporting to CSV

If using the UI method, follow these steps:

1. Run the export from Inventory → Software → All Software.

2. Choose Export → CSV.

3. Save the file as ManageEngine_SIM_Export.csv.

If using the API method, the PowerShell script automatically generates the CSV file.

Ensure the resulting CSV includes the following headers:

Preparing for SIM Import

1. Open the Licenseware SIM Template.

2. Copy and paste the exported data or import it directly from CSV.

Clean any blank rows or additional columns before saving.

👉 Learn more here

Troubleshooting

Example Output

Device Name,Software Name,Software Version,Software Publisher
LAPTOP-001,Google Chrome,129.0.6668.90,Google LLC
LAPTOP-002,Microsoft 365 Apps for Enterprise,2409,Microsoft Corporation
SERVER-01,Oracle Java SE Runtime Environment,8.0.411,Oracle Corporation
LAPTOP-003,Adobe Acrobat DC,24.002.20933,Adobe Inc.