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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
5 years ago
Top Answer
Here is the query that I use:
SELECT MACHINE.NAME, MACHINE.IP,
K.PHASE,
PSMS.PATCHED,
PSMS.NOTPATCHED,
PSMS.LAST_RUN
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
WHERE
P.DESCRIPTION = "Patch Production Deploy"
ORDER BY MACHINE.NAME
Change the "Patch Production Deploy" to the name of your patching schedule.
Comments:
-
Hi Chuck, perfect! It works fine now. I wasn't using the table 'KONDUCTOR_TASK'...
Many thanks for you quick response and solution! - amartinez 5 years ago
