Systems Management Question
Report - For each Machine in a label, what patches are not installed
11/16/2017 857 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:
WHEN MACHINE.SYSTEM_DESCRIPTION = ''
WHEN MACHINE.SYSTEM_DESCRIPTION != ''
THEN CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION)
AS MACHINE_NAME,P.TITLE AS DISPLAY_NAME, P.IDENTIFIER as KB_ARTICLE
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P
MACHINE.ID = S.MACHINE_ID and
S.PATCHUID = P.UID and
S.STATUS = 'NOTPATCHED'
order by MACHINE_NAME, P.TITLE
Be the first to answer this question