Spiceworks Data Extraction Guide (for SIM Template)

Spiceworks maintains device and software details discovered by its scanner/agent:

• Devices (Endpoints): Hostname, platform, and inventory attributes.

• Installed Applications: Display name, version, and publisher per device.

Data can be exported from the Spiceworks UI (Cloud or Classic On-Prem). For Classic On-Prem, advanced users may alternatively query the SQLite inventory database.

Prerequisites

For UI Export (Cloud or Classic On-Prem)

• Admin (or equivalent) access to the Spiceworks console.

• Recent inventory scans completed for all in-scope devices.

• Permission to run reports and export to CSV.

For SQLite Method (Classic On-Prem only; optional)

• File system access to the Spiceworks server hosting Classic Inventory.

• Read access to the SQLite database file (commonly found under the Spiceworks install data directory).

• A SQLite client (e.g., sqlite3, DB Browser for SQLite) or PowerShell with a SQLite provider/ADO.NET driver.

Recommended Query or Method

Two supported approaches are provided. The UI export is recommended for most users.

Option 1: Spiceworks UI Export (Recommended)

Cloud Inventory

1. Sign in to Spiceworks (Cloud).

2. Navigate to Inventory → Software.

3. Optional: adjust filters to include all devices/sites as required.

4. Click Export → CSV.

5. Save the file (e.g., Spiceworks_SIM_Export.csv).

6. Confirm the export includes the following fields (names may vary slightly by tenant):

   • Device (device name/hostname)

   • Application (software name)

   • Version

   • Publisher

Classic On-Prem

1. Open Spiceworks (Classic) web console.

2. Go to Inventory → Software (or Reports and create a new Software report).

3. In the report columns, include:

   • Device Name

   • Application Name

   • Version

   • Publisher

4. Run the report, then choose Export → CSV.

5. Save as Spiceworks_SIM_Export.csv.

If extra columns are present (install date, category, etc.), they can be removed prior to SIM import.

Option 2: Classic On-Prem SQLite Query (Advanced / Optional)

Use only if UI export is unsuitable or if you require automation. Schema names can vary by version; inspect the database to confirm table/column names in your environment.

Common schema pattern:

• devices (one row per device; includes name/hostname and id)

• software (catalog of software titles; includes id, display_name, publisher)

• software_installations (link table mapping device to software; includes device_id, software_id, version)

Example SQL (adapt as needed)

-- Spiceworks Classic Inventory - SIM Export (adjust table/column names to match your DB)
SELECT
    d.name                AS "Device Name",
    s.display_name        AS "Software Name",
    si.version            AS "Software Version",
    COALESCE(s.publisher, '') AS "Software Publisher"
FROM software_installations si
JOIN devices d   ON d.id = si.device_id
JOIN software s  ON s.id = si.software_id
ORDER BY d.name, s.display_name;

Running the query with sqlite3 (example)

sqlite3 "C:\ProgramData\Spiceworks\data\inventory.sqlite" -header -csv ^
"SELECT d.name AS 'Device Name', s.display_name AS 'Software Name', si.version AS 'Software Version', COALESCE(s.publisher,'') AS 'Software Publisher'
 FROM software_installations si
 JOIN devices d ON d.id = si.device_id
 JOIN software s ON s.id = si.software_id
 ORDER BY d.name, s.display_name;" > C:\Exports\Spiceworks_SIM_Export.csv

Exporting to CSV

• UI Method: Exports directly from the report or Software view. Save as Spiceworks_SIM_Export.csv.

• SQLite Method: Your command or client will write CSV output to the specified path.

Ensure the header row exactly matches:

Preparing for SIM Import

1. Open the Licenseware SIM Template.

2. Paste the CSV data into the template.

Remove blank rows and any additional columns before saving.

👉 Learn more here

Troubleshooting

Example Output

Device Name,Software Name,Software Version,Software Publisher
WS-001,Google Chrome,129.0.6668.90,Google LLC
WS-001,Microsoft Edge,130.0.2849.68,Microsoft Corporation
LAP-015,Zoom,6.1.12,Zoom Video Communications
SRV-02,Oracle Java SE Runtime Environment,8.0.411,Oracle Corporation