Ivanti Data Extraction Guide (for SIM Template)

Ivanti Endpoint Manager maintains inventory information in the following key data sources:

• Inventory Database (LDMS): Stores device and software details collected from managed endpoints.

• Software Inventory View: Contains software names, versions, and vendors associated with each computer.

• Console Reports: Allow administrators to export pre-built or custom inventory reports.

Prerequisites

For Console (UI) Method

• Access to the Ivanti Endpoint Manager Console with Inventory and Report Export permissions.

• Ensure all endpoints have completed a recent inventory scan.

• Confirm the Inventory Service is running and up to date.

For SQL or PowerShell Method

• Administrative access to the Ivanti Core Server.

• Read-only access to the LDMS database (typically Microsoft SQL Server).

• Access to SQL Server Management Studio (SSMS) or PowerShell 5.1+.

• Sufficient permissions to query and export data to CSV format.

Two primary methods are available for data extraction.

Option 1: Ivanti Console Export (UI)

This method is the simplest and recommended for non-technical users.

1. Open the Ivanti Endpoint Manager Console.

2. Navigate to:
   Tools → Reporting/Monitoring → Reports → Inventory Reports

3. Create a New Report or edit an existing one.

4. Under Data Source, select Inventory.

5. Add the following fields to your report:

   • Device Name (Computer.Device Name)

   • Software Name (Software.Package Name)

   • Software Version (Software.Version)

   • Software Publisher (Software.Publisher)

6. Click Run Report to preview results.

7. Select File → Export → CSV.

8. Save as Ivanti_SIM_Export.csv.

Tip: If your export includes additional columns (e.g., installation date or software category), these can be removed prior to SIM import.

Option 2: SQL Query (Recommended for Large Environments)

For automated or large-scale extractions, query the Ivanti inventory database directly.

SQL Query

-- Ivanti SIM Template Export Query
SELECT
    c.DeviceName AS [Device Name],
    s.DisplayName AS [Software Name],
    s.Version AS [Software Version],
    s.Publisher AS [Software Publisher]
FROM
    Computer c
JOIN
    Software s ON c.Computer_Idn = s.Computer_Idn
ORDER BY
    c.DeviceName, s.DisplayName;

Instructions:

1. Open SQL Server Management Studio.

2. Connect to your LDMS (Ivanti Core) database.

3. Execute the query above.

4. Right-click the result grid → Save Results As → CSV File.

5. Save as Ivanti_SIM_Export.csv.

Option 3: PowerShell API or Database Script (Optional Automation)

You can also retrieve the same data using PowerShell and the Ivanti database connector.

# Ivanti SIM Template Export PowerShell Script
# Requires SQL Server access and read permissions

$Server = "YOUR_SQL_SERVER"
$Database = "LDMS"
$ExportPath = "C:\Exports\Ivanti_SIM_Export.csv"

$Query = @"
SELECT
    c.DeviceName AS [Device Name],
    s.DisplayName AS [Software Name],
    s.Version AS [Software Version],
    s.Publisher AS [Software Publisher]
FROM
    Computer c
JOIN
    Software s ON c.Computer_Idn = s.Computer_Idn
ORDER BY
    c.DeviceName, s.DisplayName;
"@

$ConnectionString = "Server=$Server;Database=$Database;Integrated Security=True;"
$Data = Invoke-Sqlcmd -Query $Query -ConnectionString $ConnectionString
$Data | Export-Csv -Path $ExportPath -NoTypeInformation -Encoding UTF8

Write-Host "Export complete: $ExportPath"

This script queries the Ivanti inventory database directly and exports the results to CSV in SIM-compatible format.

Exporting to CSV

• UI Method:
  Export directly from the console’s report view as CSV.

• SQL/PowerShell Method:
  Save results manually or automatically using Export-Csv.

Ensure the resulting CSV includes the following columns:

Preparing for SIM Import

1. Open the Licenseware SIM Template.

2. Paste or import the exported CSV data.

Remove any empty or unused rows before saving.

👉 Learn more here

Troubleshooting

Example Output

Device Name,Software Name,Software Version,Software Publisher
PC-001,Google Chrome,129.0.6668.90,Google LLC
PC-002,Microsoft Office 365,2409,Microsoft Corporation
SRV-003,Oracle Java SE Runtime Environment,8.0.411,Oracle Corporation
PC-004,Adobe Acrobat Reader,24.002.20933,Adobe Inc.