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

Comments

  • Nevermind I found it. There is a canned one does exactly what I want. I was looking in Security not patches. YAY
Please log in to comment

Answers

0
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
Answered 07/28/2015 by: h2opolo25
Red Belt

Please log in to comment
0
Nevermind I found it. There is a canned one does exactly what I want. I was looking in Security not patches. YAY
Answered 07/28/2015 by: anaccarato
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity