/build/static/layout/Breadcrumb_cap_w.png

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

Answers (1)

Posted by: chucksteel 8 years ago
Red Belt
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.

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ