/build/static/layout/Breadcrumb_cap_w.png
03/12/2019 354 views

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

Comments


All Answers

2

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.

Answered 03/12/2019 by: chucksteel
Red Belt

  • 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.
  • 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 :)
    • 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.