/bundles/itninjaweb/img/Breadcrumb_cap_w.png
KACE has a report of "For each Machine, what patches are not installed" but it's SQL and I'm having trouble modifying it.

Is there any way to change this report to show For each Machine in a label, what patches are not installed? Or is it possible to rebuild this report using the wizard?

Here's the current SQL:
Select CASE
WHEN MACHINE.SYSTEM_DESCRIPTION = ''
  THEN MACHINE.NAME
WHEN MACHINE.SYSTEM_DESCRIPTION != ''
  THEN CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION)
END
AS MACHINE_NAME,P.TITLE AS DISPLAY_NAME, P.IDENTIFIER as KB_ARTICLE
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P
where
MACHINE.ID = S.MACHINE_ID and
S.PATCHUID = P.UID and
S.STATUS = 'NOTPATCHED'
order by MACHINE_NAME, P.TITLE
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers