/build/static/layout/Breadcrumb_cap_w.png

Report of All Security Patches Missing by Machine

I found this pre-made report which worked great but I'd like to target only the "security" category of patches and not all patches.
How would I go about doing that?

Below is the report which reports all patches:
http://www.itninja.com/question/k1000-report-of-all-patches-missing-by-machine

Select CASE WHEN MACHINE.SYSTEM_DESCRIPTION = '' THEN MACHINE.NAME  WHEN MACHINE.SYSTEM_DESCRIPTION != '' THEN CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) END AS MACHINE_NAME,

P.TITLE AS DISPLAY_NAME, P.IDENTIFIER as KB_ARTICLE from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P

where

MACHINE.ID = S.MACHINE_ID and

S.PATCHUID = P.UID and

S.STATUS != 'PATCHED'

order by MACHINE_NAME, P.TITLE


0 Comments   [ + ] Show comments

Answers (0)

Be the first to answer this question

 
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