/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Machine patch history

04/05/2016 1327 views
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
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1

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

Answered 04/05/2016 by: joseph.belanger@nichols.edu
Senior Yellow Belt

  • Exactly what I am looking for, thanks, Joe.
  • 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) ?

All Answers

This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.
This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.
 
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