/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Patch Tasks Report

03/15/2019 532 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!

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ