KACE report in SQL
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
I was using Machine.User_logged and machine.system_description and I needed to shorten Machine to M
Answer Chosen by the Author
I figured it out. I was using Machine.User_logged and machine.system_description and I needed to shorten Machine to M