/build/static/layout/Breadcrumb_cap_w.png

Patching Compliance

When you go to the Security Tab on the 1000, you see three graphs, one being Critical Patch Compliance. Is there a way to generate this as a simple report. I am looking for something that shows we are compliant without having such minutia of detail on each computer, each patch etc.

I just want something that shows we are xx% Compliant, or even a report that shows all computers, and just which ones are not compliant without the breakdown of each patch.

Any help is appreciated.

Thanks.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: airwolf 14 years ago
Red Belt
1
This is definitely possible, but I don't use security patching (yet) so I have no sample data to build a query from.
Posted by: Llee 13 years ago
Senior Yellow Belt
1
There is an FAQ on the Compliance Bar and there is a report there. See if this works for you or not:
http://www.kace.com/support/kb/index.php?action=artikel&cat=6&id=648&artlang=en


Try this report:
select M.NAME, P.TITLE
from PATCHLINK_MACHINE_STATUS MS,
PATCHLINK_PATCH_STATUS PS,
KBSYS.PATCHLINK_PATCH P,
MACHINE M
where MS.STATUS = 'NOTPATCHED'
and MS.DETECT_ERROR_CODE = 0
and MS.PATCHUID = P.UID
and MS.PATCHUID = PS.PATCHUID
and PS.STATUS != 1
and P.IMPACTID like 'Critical%'
and M.ID = MS.MACHINE_ID
order by M.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