Software inventory of all Computers

Question

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

Answer 1

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