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:
Please log in to answer
Posted by:
joseph.belanger@nichols.edu
8 years ago
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-
You should open a new request for this so more people see it. - joseph.belanger@nichols.edu 8 years ago
