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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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 White 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) ?
Please log in to comment

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.

Answer this question or Comment on this question for clarity