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

Comments

  • Anyway you can make that pic larger?
Please log in to comment

Answers

0

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
Answered 06/19/2013 by: dugullett
Red Belt

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

Share