/build/static/layout/Breadcrumb_cap_w.png

Machine patch history

Where machine patching history kept? 

if you select a device in the inventory, and expand "Patches Reported Installed in Software Inventory", you will see all patches deployed to that machine.

Only one month history is kept in Table ORG1.PATCHLINK_MACHINE_STATUS, so where old ones are?

Jeff

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: joseph.belanger@nichols.edu 8 years ago
Senior Yellow Belt
1

Top Answer

Try this script.  MACHINE.NAME will need to be changed.


SELECT MACHINE.NAME, MACHINE.LAST_USER, SOFTWARE.DISPLAY_NAME, SOFTWARE.PUBLISHER, SOFTWARE.INSTALL_DATE FROM ORG1.SOFTWARE
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE IS_PATCH = 1
and MACHINE.NAME = "ComputersHostName"
ORDER BY INSTALL_DATE DESC


Comments:
  • Exactly what I am looking for, thanks, Joe. - jliu@mususa.com 8 years ago
  • I can get all patches loaded on a device

    SELECT MACHINE.NAME, SOFTWARE.DISPLAY_NAME
    FROM ORG1.SOFTWARE
    JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
    JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
    WHERE IS_PATCH = 1 AND YEAR(ORG1.SOFTWARE.CREATED) = '2016' AND MACHINE.NAME = ‘device_name’
    ORDER BY INSTALL_DATE DESC


    I can get recent patches

    SELECT M.NAME, PP.TITLE
    FROM ORG1.PATCHLINK_MACHINE_STATUS MS
    JOIN MACHINE M ON M.ID = MS.MACHINE_ID
    JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
    WHERE M.NAME = 'device_name'
    ORDER BY PP.TITLE

    But how can patches and patches as software being matched (linked) ? - jliu@mususa.com 8 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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