/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Need Help Modifying A report on Kace 10

12/27/2019 361 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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ