/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Report to find all computers with specific software installed.

03/12/2019 689 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.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ