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.
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)
Please log in to answer
Posted by:
airwolf
14 years ago
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
14 years ago
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
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.