/build/static/layout/Breadcrumb_cap_w.png
11/16/2017 739 views
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   [ + ] Show comments

Comments


There are no answers at this time