Patch Schedule report
I have created several schedules. The auditors would like a report on those schedules for patches. When I go to schedules and click click on Create report. It creates a report that is broken. What I would really like and I'm not an SQL guru, is a report that shows me the schedules and which systems are in that schedule. for example: If I have test systems scheduled to detect daily at a specific time and the names of those test systems in the report.
Can anyone help me out. Give me basic's I'll work the rest.
Please log in to answer
Posted by: h2opolo25 5 years ago
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 = 'JOB NAME'
and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE
Posted by: anaccarato 5 years ago