/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

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?
  • 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.
Please log in to comment

Answer this question or Comment on this question for clarity

Answers

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


Answered 02/13/2018 by: DaveMT
Second Degree Black Belt

Please log in to comment
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.
Answered 02/14/2018 by: chucksteel
Red Belt

Please log in to comment