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

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

1
This is definitely possible, but I don't use security patching (yet) so I have no sample data to build a query from.
Answered 03/22/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
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
Answered 12/29/2010 by: Llee
Senior Yellow Belt

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