Report to find all computers with specific software installed.
i am looking for an report that can view which versions installed on each computer of an specific software catalog.
Now i am able to see which are installed but i am not able to see which is installed on which computer. Is there an way to export this in an report so i can see each version under an colum.
Here is a report of all computers with a title from the software catalog installed along with which version is installed:
SELECT SAM_CATALOG.NAME as "Software", SAM_CATALOG.PUBLISHER, MAJOR_VERSION,
MACHINE.NAME as "Computer"
JOIN ORG1.SAM_MACHINE_JT on SAM_MACHINE_JT.SAM_CATALOG_ID = SAM_CATALOG.ID
JOIN ORG1.MACHINE on MACHINE.ID = SAM_MACHINE_JT.MACHINE_ID
WHERE SAM_CATALOG.NAME = 'Google Chrome'
ORDER BY MACHINE.NAME
Note that if you are just interested in viewing the computers with a particular version of a title installed, clicking on the number in the installed column will take you to the inventory page and show you those computers.