/build/static/layout/Breadcrumb_cap_w.png

Report based on Job Schedule

gFOEPk.jpegI would like to generate a report that contains the information based on job schedule without the detail of each computer.  Basically with this information
LhJ84G.png

2 Comments   [ + ] Show comments
  • I can't really see the image (it's very blurry), but it looks like a patching schedule, is that correct? Do you want a report that shows the number of computers in each state of a patching schedule? - chucksteel 6 years ago
  • yes it is a patching schedule. If you could see the image, it shows number of successful, number of failed, etc etc and total percentage. I want a report that shows just that summarized information. Not detail with every machine. - kspencer@fmh.org 6 years ago

Answers (2)

Posted by: DaveMT 6 years ago
4th Degree Black Belt
0

This is the report I use.  Do note that you will need to change the PSS.SECSCRIPTION to your Schedule name.  Hopefully it will guide you into the direction you are looking for.



select M.NAME as NAME, SYSTEM_DESCRIPTION as Description, 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 LAST_RUN_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 = 'PATCHSCHEDULENAME'

and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE


Posted by: chucksteel 6 years ago
Red Belt
0
Here is what I came up with:
SELECT DESCRIPTION, LAST_RUN,
PENDING, DOWNLOADING, EXECUTING, 
REBOOTING, PAUSED, SUCCEEDED, 
FAILED, COMPLETED, OFFLINE 
FROM ORG1.PATCHLINK_SCHEDULE_RUN_COUNTS
JOIN PATCHLINK_SCHEDULE on PATCHLINK_SCHEDULE.ID = PATCHLINK_SCHEDULE_RUN_COUNTS.PATCHLINK_SCHEDULE_ID
WHERE PATCHLINK_SCHEDULE.DESCRIPTION = "Patch Production Deploy"
and PATCHLINK_SCHEDULE_RUN_COUNTS.ID = 
(SELECT MAX(PATCHLINK_SCHEDULE_RUN_ID) 
FROM PATCHLINK_SCHEDULE_RUN_COUNTS 
WHERE PATCHLINK_SCHEDULE_ID = PATCHLINK_SCHEDULE.ID)
Be sure to change "Patch Production Deploy" to your schedule's name.

Don't be a Stranger!

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

Sign up! or login

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