/build/static/layout/Breadcrumb_cap_w.png
12/07/2017 829 views
Hello, 

I am using the following patch report for change management though I want to tweak the report so it only pulls OS category patches (not app). Any thoughts on how to modify this?

Break Colums: COMPUTER_NAME


SELECT PP.TITLE AS PATCH_NAME,
M.NAME AS COMPUTER_NAME,
OS_NAME AS WINDOWS_VERSION,
DATE_FORMAT(PP.RELEASEDATE, '%Y-%m-%d') AS RELEASED
FROM PATCHLINK_MACHINE_STATUS MS
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
JOIN PATCHLINK_PATCH_STATUS PPS ON PPS.PATCHUID = PP.UID
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID)
JOIN LABEL L ON (ML.LABEL_ID = L.ID)
WHERE L.NAME = 'Toronto Production Servers'
AND MS.STATUS = 'NOTPATCHED'
AND PP.IMPACTID = ('Critical')
AND PPS.STATUS in (0)
ORDER BY M.NAME, PP.RELEASEDATE, PP.TITL
0 Comments   [ + ] Show comments

Comments


All Answers

0
Try adding in the following line
AND PP.IS_APP = '0'
maybe between lines 12 and 13
This flag field is =1 if the patch is application and 0 if it is an OS patch
Answered 12/21/2017 by: Hobbsy
Red Belt