KACE Product Support

I had a perfect patching report that ran weekly which would generate a report of patched installed, patches needed and percentage patched.  Since the K1000 SMA 10.x update, the query will not run, citing the following access denied error:

mysqli error: [1142: SELECT command denied to user 'R1'@'localhost' for table 'PATCHLINK_PATCH'] in EXECUTE("SELECT M.NAME AS MACHINE_NAME, M.ID, OS_NAME AS WINDOWS_VERSION, SUM(MS.STATUS = 'PATCHED') AS PATCHED, SUM(MS.STATUS = 'NOTPATCHED') AS NOTPATCHED, ROUND( (SUM(MS.STATUS = 'PATCHED') / (SUM(MS.STATUS = 'PATCHED') + SUM(MS.STATUS = 'NOTPATCHED'))) * 100, 0) AS PERCENT_PATCHED FROM MACHINE M LEFT JOIN PATCHLINK_MACHINE_STATUS MS ON M.ID = MS.MACHINE_ID LEFT JOIN KBSYS.PATCHLINK_PATCH PP ON MS.PATCHUID = PP.UID LEFT JOIN PATCHLINK_PATCH_STATUS PPS ON PP.UID = PPS.PATCHUID JOIN MACHINE_LABEL_JT ML ON M.ID = ML.MACHINE_ID JOIN LABEL L ON ML.LABEL_ID = L.ID WHERE L.NAME = 'Windows Servers - ALL - 8-8-18 - RN' AND PP.IS_SUPERCEDED = 0 # AND PPS.STATUS = 0 # GROUP BY M.NAME ORDER BY PERCENT_PATCHED, M.NAME")

Here is the full text of my query:

SELECT
      M.NAME AS MACHINE_NAME,
      M.ID,
      OS_NAME AS WINDOWS_VERSION,
      SUM(MS.STATUS = 'PATCHED') AS PATCHED,
      SUM(MS.STATUS = 'NOTPATCHED') AS NOTPATCHED,
      ROUND(
          (SUM(MS.STATUS = 'PATCHED') /
            (SUM(MS.STATUS = 'PATCHED') + SUM(MS.STATUS = 'NOTPATCHED'))) * 100, 0)
        AS PERCENT_PATCHED
FROM     MACHINE M
         LEFT JOIN PATCHLINK_MACHINE_STATUS MS ON M.ID = MS.MACHINE_ID
         LEFT JOIN KBSYS.PATCHLINK_PATCH PP ON MS.PATCHUID = PP.UID
         LEFT JOIN PATCHLINK_PATCH_STATUS PPS ON PP.UID = PPS.PATCHUID
         JOIN MACHINE_LABEL_JT ML ON M.ID = ML.MACHINE_ID
         JOIN LABEL L ON ML.LABEL_ID = L.ID
WHERE   L.NAME = 'Windows Servers - ALL - 8-8-18 - RN'
        AND PP.IS_SUPERCEDED = 0
        # AND PPS.STATUS = 0 #
GROUP BY M.NAME
ORDER BY PERCENT_PATCHED, M.NAME

Can anyone out there please help me convert this to work with version 10.x of KACE?

-Russ N.