I want to create a report giving me the name. IP address, status for each machine, patch results as patched, not patched, detect failures, if failed - what is the reason and date. Please help. Thanks
I am able to generate report which gives me almost everything what I need. The problem is for some machines status is missing and if failed, not able to expand it as why it is failed. Also for some machines getting some weird dates like almost 3-4 years back dates.
3 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
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
and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE - adeeshp 8 years ago
Also, in order to get error codes you need to select from specific patches in the PATCHLINK_MACHINE_STATUS table. - chucksteel 8 years ago