Need Help Modifying A report on Kace 10
I have a patching report that I cannot seem to recreate. Here is the SQL:
MS.DEPLOY_STATUS_DT as 'LAST DEPLOYED',
COUNT(*) AS TOTAL,
SUM(IF((MS.STATUS = 'PATCHED'), 1, 0)) AS PATCHED,
SUM(IF((MS.STATUS = 'NOTPATCHED'), 1, 0)) AS NOTPATCHED,
SUM(IF((MS.DEPLOY_ATTEMPT_COUNT >= 3
and MS.STATUS != 'PATCHED'
or MS.STATUS = 'FAIL'
or MS.DEPLOY_STATUS = 'FAIL'), 1, 0)) AS ERROR
FROM PATCHLINK_MACHINE_STATUS MS
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
where MS.DEPLOY_STATUS_DT > DATE_SUB(CURDATE(), INTERVAL 5 DAY)
GROUP BY PP.UID
ORDER BY PP.TITLE
Can anyone help change the columns and tables to the new names? I can get most of them changed, but I'm still getting errors.