Is this possible for a patch report?
Good afternoon,
I was wondering if anyone could tell me if KACE would be able to generate a report that would follow these guide lines.
1 Comment
[ + ] Show comment
-
Anyway you can make that pic larger? - dugullett 11 years ago
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
Based on what I can see this is a start.
SELECT PP.TITLE, PP.IMPACTID, PP.RELEASEDATE, SUM(IF((MS.STATUS = 'PATCHED'), 1, 0)) AS '# of Servers Installed', SUM(IF((MS.STATUS = 'NOTPATCHED'), 1, 0)) AS '# of Servers Needed', SUM(IF((MS.DEPLOY_ATTEMPT_COUNT >= MS.MAX_DEPLOY_ATTEMPT and MS.STATUS != 'PATCHED' or MS.STATUS = 'FAIL' or (MS.DEPLOY_STATUS = 'FAIL' and MS.STATUS != 'PATCHED')), 1, 0)) AS '# Servers Failed' FROM PATCHLINK_MACHINE_STATUS MS JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID GROUP BY PP.UID ORDER BY PP.TITLE
