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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share