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
14 years ago
Posted by:
jg1000c
14 years ago
Posted by:
jg1000c
14 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
14 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.
so that the conversation will remain readable.