/build/static/layout/Breadcrumb_cap_w.png
04/01/2019 247 views

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

Answer Summary:
I was using Machine.User_logged and machine.system_description and I needed to shorten Machine to M
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0

I figured it out. I was using Machine.User_logged and machine.system_description and I needed to shorten Machine to M

Answered 04/02/2019 by: dschraplau
Senior White Belt