/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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