I can get all patches loaded on a device from ORG1.Software

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 
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 ?

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
You could try checking if ORG1.SOFTWARE.HELP_LINK matches with KBSYS.PATCHLINK_PATCH.HYPERLINK matches. When looking for patches installed on machines I generally use the ORG1.PATCHLINK_MACHINE_STATUS table, however. There is a direct link between ORG1.PATCHLINK_MACHINE_STATUS.PATCHUID and KBSYS.PATCHLINK_PATCH.UID.

Answered 04/11/2016 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share