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.
Thanks,
1 Comment
[ + ] Show comment
-
Nevermind I found it. There is a canned one does exactly what I want. I was looking in Security not patches. YAY - anaccarato 8 years ago
Answers (2)
Please log in to answer
Posted by:
h2opolo25
8 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
8 years ago
Nevermind I found it. There is a canned one does exactly what I want. I was looking in Security not patches. YAY