How to associate patches list in ORG1.Software table and KBSYS.PATCHLINK_PATCH table
I can get all patches loaded on a device from ORG1.Software
SELECT MACHINE.NAME, SOFTWARE.DISPLAY_NAME
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 from KBSYS.PATCHLINK_PATCH
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 they be associated or they are just in different scope ?