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.

Software inventory of all Computers

Hello,

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?
TIA
in Administrative console by (420 points)

1 Answer

+1 vote
 
Best answer

Hi,

The only solution I known is a SQL query :

SELECT
    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

Regards

by (6.2k points)
selected by
 
Powered by Question2Answer
...