/build/static/layout/Breadcrumb_cap_w.png
03/15/2019 98 views

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 Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0

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.

Answered 03/15/2019 by: chucksteel
Red Belt

  • Hi Chuck, perfect! It works fine now. I wasn't using the table 'KONDUCTOR_TASK'...

    Many thanks for you quick response and solution!