Help Creating Machine listing and patch status
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
Answers (4)
Please log in to answer
Posted by:
DContreras
13 years ago
Are you using patch labels to determine what patches that you want your machines to apply?
Posted by:
jg1000c
13 years ago
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?
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?
Posted by:
jg1000c
13 years ago
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
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
Posted by:
jg1000c
13 years ago
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
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.