/build/static/layout/Breadcrumb_cap_w.png

Security Question


Patch Schedule report

07/28/2015 1671 views
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

All Answers

1
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

1
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ