Patch Tasks Report
I've been trying to create a simple SQL report showing a Patch Task status for a created Patching schedule task. From Kace SMA > Patch Management > Schedules > [Task] you can scroll at the end of the task and click over [Show All], and you will see the Patch status for the selected affected devices. I tried to create an SQL query report, without getting the same information. I can get the status (for example) but then "Patch Results" don't match, or vice-versa. I'd appreciate any help on creating this report. I've attached an screenshot of what report should show. Thanks in advance.
Answer Chosen by the Author
Here is the query that I use:
SELECT MACHINE.NAME, MACHINE.IP,
FROM PATCHLINK_SCHEDULE_MACHINE_STATUS PSMS
JOIN MACHINE on MACHINE.ID = PSMS.MACHINE_ID
JOIN PATCHLINK_SCHEDULE P on P.ID = PSMS.PATCHLINK_SCHEDULE_ID
JOIN KBSYS.KONDUCTOR_TASK K ON P.KONDUCTOR_TASK_TYPE = K.TYPE and K.KUID = MACHINE.KUID
P.DESCRIPTION = "Patch Production Deploy"
ORDER BY MACHINE.NAME
Change the "Patch Production Deploy" to the name of your patching schedule.