Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

Categories

Any way to link the inventory csv to excel?

Hello,i would like to have a constantly updated inventory in a excel sheet in a folder in my company, but i dont really have a clue if that is possible or how to do it. If anyone did a similar process, or has a plugin or program that does that, it would be appreciated.
in OCS Inventory NG server for Windows by (120 points)
Share on
share on gp share on fb share on tw share on li

1 Answer

0 votes
OCS Server store all informations in a MySQL (MariaDB) database and update data when agents send its own inventory.

You have the abilities, at anytime, in 'All Computers', to select columns and then export (Download) a CSV file to import in a Excel (Calc) file. it's very quick to do.

Better, OCS had an integrated search module, with again the column's selection and export (Download)

So I don't understand why use an Excel file would provided 'better usage' than direct access thru web interface ...

As the selection of columns and download is based on a SQL instructions, it's possible to use Excel Connections to get the same informations in Excel file : you need to search in tables of database : main informations are in table 'hardware', but if you want also administrative fields it will be harder ...
by (20.1k points)
edited by
 
Powered by Question2Answer
...