Report - For each Machine in a label, what patches are not installed
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
Answers (0)
Please log in to answer
Be the first to answer this question
