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.11.1 available

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

Report for specific software inventory

Hello all,

We're using OCS for ou assets inventory. When we have to replace a computer we're using it in order to export/view software list and find which sotware need to be reinstalled. But I'm searching for a simple report or sql query where I can directly have for a dedicated device (where device name is a variable) the software list with some exclusions (like all Microsoft update, all constructors software, etc.). I just want to see software that need to be installed (Collaboration tools, 7-Zip, Adobe, Autocad, etc.).

Do you know if it's possible ?

Tks in advance.

in Administrative console by (160 points)

2 Answers

0 votes
Hi, you can export the list from web page ocs from detail pc.

you can also export from sql with a query like this:

select c.name,b.name from software a, software_name b, hardware c where c.name='myPcName' and c.id=a.hardware_id and a.name_id=b.id;


by (260 points)
0 votes

Tks :) I'll look at that.

by (160 points)
Powered by Question2Answer