/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: DContreras 11 years ago
Orange Belt
0
Are you using patch labels to determine what patches that you want your machines to apply?
Posted by: jg1000c 11 years ago
Orange Belt
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?
Posted by: jg1000c 11 years ago
Orange Belt
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
Posted by: jg1000c 11 years ago
Orange Belt
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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