Hi, I need assistance creating a report that will list all patches that are Active, Critical, not Superseded and there is a machine that either has already been patched or needs to be patched. I want to weed out Patches that are enabled but don't have computers that they could be pushed to (0 patched , 0 not patched, 0 error).
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Are you using patch labels to determine what patches that you want your machines to apply?
Answered 08/30/2010 by: DContreras
Orange Belt

Please log in to comment
0
Hi,

Yes we are using labels, I want the order to be

List Machine Name based on label group, then under machine name, list all the patches that is is missing, then go to the next machine, make sense?
Answered 09/13/2010 by: jg1000c
Orange Belt

Please log in to comment
0
I found a canned report that lists Machines and the patches that have been applied, I modified it to list the patches that have not been installed, just need to filter a little more on machine label.

Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) 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 = 'NOTPATCHED'
order by MACHINE_NAME, P.TITLE
Answered 09/13/2010 by: jg1000c
Orange Belt

Please log in to comment
0
Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, P.TITLE AS DISPLAY_NAME, P.IDENTIFIER as KB_ARTICLE from PATCHLINK_MACHINE_STATUS S, MACHINE LEFT JOIN MACHINE_LABEL_JT ON MACHINE.ID=MACHINE_LABEL_JT.MACHINE_ID LEFT JOIN LABEL ON MACHINE_LABEL_JT.LABEL_ID=LABEL.ID, KBSYS.PATCHLINK_PATCH P

where
MACHINE.ID = S.MACHINE_ID and
S.PATCHUID = P.UID and
S.STATUS = 'NOTPATCHED' and
LABEL.NAME = '1'
order by MACHINE_NAME, P.TITLE
Answered 09/16/2010 by: jg1000c
Orange Belt

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