Kace - Help with Schedule Status Report
I was looking to generate a report that basically duplicates the schedule deploy status (Called "Patch Tasks") that's found at the bottom of the schedule setup screen (ie... see the image below). I found a built in report that I modified simply to include the name of the schedule I want to view, however it doesn't display the exact same list as the image below. I determined that the SQL statement of the report doesn't include systems that have Patch Results as "Unavaliable".
Is there a report that basically duplicates what is seen in the image below, or can anyone assist in getting my SQL code to also display systems that are Unavailable just like the image. Either way would be a huge help :-). I've pasted my SQL code below the image. Thanks
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, PSS.DESCRIPTION as Schedule
from MACHINE M
left join PATCHLINK_SCHEDULE_MACHINE_STATUS PS on
PS.MACHINE_ID = M.ID
left join PATCHLINK_SCHEDULE PSS on PSS.ID =
left join KBSYS.KONDUCTOR_TASK KT on KT.KUID = M.KUID
where KT.TYPE = PSS.KONDUCTOR_TASK_TYPE and PSS.DESCRIPTION
= 'PM - WORKSTATIONS (ACTIVE SYSTEMS)'
order by M.NAME