Report to find all computers with specific software installed.
Hi,
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.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
5 years ago
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"
FROM CATALOG.SAM_CATALOG
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.
Comments:
-
Thank you this looks almost good for me. Can i also show :
Google Chrome 62.x
Google Chrome 64.x
and than under this i want the computer name if possible also logged in username. - nldenic 5 years ago -
I think i have find it :
SELECT SAM_CATALOG.NAME as "Software", SAM_CATALOG.PUBLISHER, MAJOR_VERSION,MACHINE.USER,
MACHINE.NAME as "Computer"
FROM CATALOG.SAM_CATALOG
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 like 'Google Chrome 5%'
OR SAM_CATALOG.NAME like 'Google Chrome 6%'
OR SAM_CATALOG.NAME like 'Google Chrome 4%'
OR SAM_CATALOG.NAME like 'Google Chrome 3%'
OR SAM_CATALOG.NAME like 'Google Chrome 2%'
OR SAM_CATALOG.NAME like 'Google Chrome 1%'
OR SAM_CATALOG.NAME like 'Google Chrome 71%'
ORDER BY MAJOR_VERSION
looks ok now for me :) - nldenic 5 years ago-
For simplicity, I would recommend using SAM_CATALOG.NAME like 'Google Chrome%' instead of including the numbers. Specifying the numbers in the query really isn't doing anything, other than slowing down the query. - chucksteel 5 years ago
