/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Need Help Modifying A report on Kace 10

12/27/2019 233 views

I have a patching report that I cannot seem to recreate.  Here is the SQL:


SELECT PP.IDENTIFIER,
PP.TITLE,
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.

0 Comments   [ + ] Show comments

Comments


All Answers

2

You can review this article:
https://support.quest.com/kb/309572/

It shows the schema changes, so you can find the answer.


Answered 12/27/2019 by: Nico_K
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share