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

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

Software inventory of all Computers


I can download a list of installed software, however I see that it gives me a count of computers only. Is there a way that I can download a report which includes the computer ID of installed software?
in Administrative console by (420 points)

1 Answer

+1 vote
Best answer


The only solution I known is a SQL query :

    DISTINCT s.hardware_id, publisher, s.name, s.version, h.name
FROM softwares as s, hardware as h
    WHERE s.name LIKE  'Microsoft Office 2%'
    AND h.id=s.HARDWARE_ID
    ORDER BY hardware_id, s.publisher, s.name, s.version


by (6.2k points)
selected by
Powered by Question2Answer