KACE Product Support

Since the 10.x update, I have a patch report that errors when trying to run. I have looked over the database schema changes but I can't seem to fix the SQL on the report to get it to work. I get the following error: 

mysqli error: [1142: SELECT command denied to user 'R1'@'localhost' for table 'PATCHLINK_PATCH'] in EXECUTE("SELECT DISTINCT M.NAME, PM.STATUS_DT AS 'DETECT DATE', COUNT(P.TITLE) AS NUM_OF_PATCHES_NEEDED, IFNULL(PATCHINSTALLED.NUM_OF_PATCHES_INSTALLED,0) AS NUM_PATCHES_INSTALLED, (COUNT(P.TITLE) - IFNULL(PATCHINSTALLED.NUM_OF_PATCHES_INSTALLED,0)) AS NUM_OF_PATCHES_MISSING, ROUND(IFNULL(PATCHINSTALLED.NUM_OF_PATCHES_INSTALLED,0) / COUNT(P.TITLE) * 100,2) AS PERCENT_COMPLETE FROM MACHINE M LEFT JOIN PATCHLINK_MACHINE_STATUS PM ON M.ID=PM.MACHINE_ID LEFT JOIN KBSYS.PATCHLINK_PATCH P ON P.UID=PM.PATCHUID left join (SELECT DISTINCT M.ID, COUNT(P.TITLE) AS NUM_OF_PATCHES_INSTALLED FROM MACHINE M LEFT JOIN PATCHLINK_MACHINE_STATUS PM ON M.ID=PM.MACHINE_ID LEFT JOIN KBSYS.PATCHLINK_PATCH P ON P.UID=PM.PATCHUID WHERE P.IMPACTID = 'Critical' AND P.IS_APP = '0' AND P.IS_SUPERCEDED != '1' AND PM.STATUS = 'PATCHED' AND OS_NAME NOT LIKE '%Server%' GROUP BY M.ID ORDER BY NUM_OF_PATCHES_INSTALLED) as PATCHINSTALLED on PATCHINSTALLED.ID = M.ID WHERE P.IMPACTID = 'Critical' AND P.IS_APP = '0' AND P.IS_SUPERCEDED != '1' AND OS_NAME NOT LIKE '%Server%' GROUP BY M.ID ORDER BY NUM_OF_PATCHES_MISSING ASC, M.NAME ASC")

Full SQL query: 

SELECT DISTINCT M.NAME, PM.STATUS_DT AS 'DETECT DATE',
COUNT(P.TITLE) AS NUM_OF_PATCHES_NEEDED, IFNULL(PATCHINSTALLED.NUM_OF_PATCHES_INSTALLED,0) AS NUM_PATCHES_INSTALLED,
(COUNT(P.TITLE) - IFNULL(PATCHINSTALLED.NUM_OF_PATCHES_INSTALLED,0)) AS NUM_OF_PATCHES_MISSING,
ROUND(IFNULL(PATCHINSTALLED.NUM_OF_PATCHES_INSTALLED,0) / COUNT(P.TITLE) * 100,2) AS PERCENT_COMPLETE
FROM MACHINE M
LEFT JOIN PATCHLINK_MACHINE_STATUS PM ON M.ID=PM.MACHINE_ID
LEFT JOIN KBSYS.PATCHLINK_PATCH P ON P.UID=PM.PATCHUID

left join
(SELECT DISTINCT M.ID, COUNT(P.TITLE) AS NUM_OF_PATCHES_INSTALLED
FROM MACHINE M
LEFT JOIN PATCHLINK_MACHINE_STATUS PM ON M.ID=PM.MACHINE_ID
LEFT JOIN KBSYS.PATCHLINK_PATCH P ON P.UID=PM.PATCHUID
WHERE
P.IS_APP = '0' AND
P.IS_SUPERCEDED != '1' AND
PM.STATUS = 'PATCHED' AND
OS_NAME NOT LIKE '%Server%'
GROUP BY M.ID
ORDER BY NUM_OF_PATCHES_INSTALLED) as PATCHINSTALLED on PATCHINSTALLED.ID = M.ID

WHERE
P.IS_APP = '0' AND
P.IS_SUPERCEDED != '1' AND
OS_NAME NOT LIKE '%Server%'
GROUP BY M.ID
ORDER BY PERCENT_COMPLETE ASC, M.NAME ASC

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