Miscellaneous

I have the following report that gives me info on a patching schedule. I'm trying to add in system discription and last logged on user. I'm not great with SQL but i'm getting errors. I this due to pulling from the schedule?

select M.NAME as NAME, M.IP as IP_ADDRESS, KT.PHASE as STATUS, Concat('Patched: ', PS.PATCHED,' , ','Not Patched: ',  PS.NOTPATCHED,' , ','Detect Failures: ',  PS.DETECT_FAILURES) as PATCH_RESULTS, PS.LAST_RUN as DATE 

from MACHINE M

left join PATCHLINK_SCHEDULE_MACHINE_STATUS PS on PS.MACHINE_ID = M.ID

left join PATCHLINK_SCHEDULE PSS on PSS.ID = PS.PATCHLINK_SCHEDULE_ID

left join KBSYS.KONDUCTOR_TASK KT on KT.KUID = M.KUID

where PSS.DESCRIPTION = 'Deploy-Adobe Patching'

and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE

ORDER BY KT.PHASE