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

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share