Export full inventory to CSV/Excel

Question

Hello OCS Community,

I am a new user of OCS Inventory and I am currently managing a migration project. I have successfully set up the server and deployed the agents to my network.

I need to extract a full report of ALL the computers registered in the server to a single Excel or CSV file.

Specifically, I need columns for:

- Computer Name and User

- Hardware info (RAM, CPU, HDD)

- Operating System

- Installed Software (specifically to filter Microsoft Office, LibreOffice, etc.)

Is there a native way in the Web Console to export this custom "mass report"? Or could you suggest a SQL query to extract this directly from the database?

My Environment:

- Server OS: [Ubuntu 22.04 LTS]

- OCS Server Version: [2.12.3]

- OCS Agent Version: [Windows Agent 2.11.0.1 (64 bits)]

Thank you very much for your help.

Answer 1

There is no single built‑in “one click” export for exactly that custom dataset, but you can get close from the console and, for full control, use a SQL query on the OCS database

Go to All Computers → Inventory / Search

Build a query with criteria you want (or simply “all computers”), then use the column selector to add:

    Computer name

    User logged in

    Memory, processor, disk info

    Operating system
    These fields are available in the standard search parameters.
    Run the query, then use the export function (CSV) from the result list. OCS can export inventory query results to CSV, which you can open directly in Excel.
    This export will not list all installed software per machine in the same row; software is a separate table and is usually reported either per machine detail or via software‑centric reports

For a full “flat” CSV with basic hardware, OS, and software like Microsoft Office / LibreOffice, you can query the OCS MySQL/MariaDB database directly and then redirect the result to CSV